| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP08: Human Resources |
1 | F085550 | Employee Self-Service Personal Information Options | 2 | IO | PIDI | Personal Information Data Item | String | UDC | 10 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 08 / DI (Data Items for Form Options) stock values
| Value | Description | Special Handling Code | Hard Coded |
---|
1 | ADD1 | Address 1 | | Y |
2 | ADD2 | Address 2 | | Y |
3 | ADD3 | Address 3 | | Y |
4 | ADD4 | Address 4 | | Y |
5 | ADDS | State | | Y |
6 | ADDZ | Zip Code | | Y |
7 | AN8 | Employee Number | | Y |
8 | ANPA | Supervisor | | Y |
9 | AR1 | Prefix | | Y |
10 | ATTL | Professional Title | | Y |
11 | BSCDTL | Business Card Title | | Y |
12 | CO | Company | | Y |
13 | COUN | County | | Y |
14 | CTR | Country | | Y |
15 | CTY1 | City | | Y |
16 | DEPTAX | Dependent/Beneficiary Tax ID | | Y |
17 | DOB | Date of Birth | | Y |
18 | DSBD | Date of Disability | | Y |
19 | DSBF | Disabled | | Y |
20 | DTDH | Date of Death | | Y |
21 | EMAL | Electronic Address | | Y |
22 | EMP | Employed | | Y |
23 | ETP | Electronic Address Type | | Y |
24 | FTS | Full Time Student | | Y |
25 | GNNM | Given Name | | Y |
26 | HMCU | Home Business Unit | | Y |
27 | HSG | High School Grad | | Y |
28 | IMN | Middle Initial | | Y |
29 | JBCX | Job Title | | Y |
30 | MCDT | Date of Medicare | | Y |
31 | MDNM | Name Middle | | Y |
32 | MLNM | Mailing Name | | Y |
33 | PH1 | Phone | | Y |
34 | PHTP | Phone Type | | Y |
35 | PRNM | Preferred Name | | Y |
36 | RELA | Relationship | | Y |
37 | REM1 | Remark | | Y |
38 | SCA | School Attending | | Y |
39 | SEX | Gender | | Y |
40 | SLNM | Salutation Name | | Y |
41 | SPRVN | Primary Supervisor Name | | Y |
42 | SRNM | Surname | | Y |
43 | TAX | Tax ID | | Y |
44 | TYC | Type Code | | Y |