| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | XJTINC | Type of Increase Next Review | Character | UDC (06 RV) | 1 | 0 | Allow NULL? |
| 2 | XJANPA | Supervisor | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 3 | XJAN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 4 | XJDEF | Date - Effective | Date | Generic Edit | 6 | 0 | |
| 5 | XJGAPS | Gap Status | String | UDC (08 GT) | 3 | 0 | Allow NULL? |
| 6 | XJFRVW | Date - From Review | Date | Generic Edit | 6 | 0 | |
| 7 | XJTRVW | Date - Thru Review | Date | Generic Edit | 6 | 0 | |
| 8 | XJPADD | Date - Performance Appraisal Due | Date | Generic Edit | 6 | 0 | |
| 9 | XJESADD | Date - Employee Self Appraisal Due | Date | Generic Edit | 6 | 0 | |
| 10 | XJOTPS | Organization Type Structure | String | UDC (00 TS) | 3 | 0 | Allow NULL? |
| 11 | XJORMCU | Organizational Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 12 | XJPOS | Position ID | String | Generic Edit | 8 | 0 | Allow NULL? |
| 13 | XJNPDL01 | New Position Description | String | Generic Edit | 30 | 0 | Allow NULL? |
| 14 | XJJGRP | Job Group | String | UDC (08 JG) | 6 | 0 | Allow NULL? |
| 15 | XJJBCD | Job Type (Craft) Code | String | UDC (06 G) | 6 | 0 | Allow NULL? |
| 16 | XJJBST | Job Step | String | UDC (06 GS) | 4 | 0 | Allow NULL? |
| 17 | XJDESCJTS | Description of Job Type/Step | String | Generic Edit | 30 | 0 | Allow NULL? |
| 18 | XJJBCX | Job Title | String | Generic Edit | 30 | 0 | Allow NULL? |
| 19 | XJCPDT | Date - Current Position | Date | Generic Edit | 6 | 0 | |
| 20 | XJCDIJ | Date in Current Job | Date | Generic Edit | 6 | 0 | |
| 21 | XJDST | Data Item - Secondary | Date | Generic Edit | 6 | 0 | |
| 22 | XJSAPL | Employee Self-Appraisal Level | Numeric | Generic Edit | 6 | 3 | Allow NULL? |
| 23 | XJSAPLDS | Emp. Self-Appraisal Level Description | String | Generic Edit | 30 | 0 | Allow NULL? |
| 24 | XJNCMPV | New Competency Level | Numeric | Generic Edit | 6 | 3 | Allow NULL? |
| 25 | XJNCMPDS | New Competency Level Description | String | Generic Edit | 30 | 0 | Allow NULL? |
| 26 | XJPAPL | Performance Appraisal Level | Numeric | Generic Edit | 6 | 3 | Allow NULL? |
| 27 | XJPAPLDS | Performance Appraisal Level Description | String | Generic Edit | 30 | 0 | Allow NULL? |
| 28 | XJPACM | Management Appraisal Method | Character | UDC (08 ME) | 1 | 0 | Allow NULL? |
| 29 | XJSCLES | Supervisor Rating Scale | String | Generic Edit | 10 | 0 | Allow NULL? |
| 30 | XJREQLS | Required Performance Level | Numeric | Generic Edit | 6 | 3 | Allow NULL? |
| 31 | XJRQSDS | Required Performance Level Description | String | Generic Edit | 30 | 0 | Allow NULL? |
| 32 | XJESARQ | Employee Self Appraisal Required | Character | UDC (00 ZO) | 1 | 0 | Allow NULL? |
| 33 | XJPABM | Employee Self Appraisal Method | Character | UDC (08 ME) | 1 | 0 | Allow NULL? |
| 34 | XJESAS | Employee Self Appraisal Status | String | UDC (08 SA) | 3 | 0 | Allow NULL? |
| 35 | XJSCLEE | Employee Rating Scale | String | Generic Edit | 10 | 0 | Allow NULL? |
| 36 | XJREQLE | Required Self Appraisal Level | Numeric | Generic Edit | 6 | 3 | Allow NULL? |
| 37 | XJRQEDS | Required Self Appraisal Level Desc. | String | Generic Edit | 30 | 0 | Allow NULL? |
| 38 | XJPASTA | Performance Appraisal Started | Character | UDC (00 ZO) | 1 | 0 | Allow NULL? |
| 39 | XJAPPST | Approval Status | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 40 | XJANAB | Responding Supervisor | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 41 | XJLVEL | Level In Relation To Employee | Integer | Generic Edit | 3 | 0 | Allow NULL? |
| 42 | XJLARD | Last Approved/Rejected Date | Date | Generic Edit | 6 | 0 | |
| 43 | XJSERK | Key Value Serial Number | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 44 | XJTORG | Transaction Originator | String | Generic Edit | 10 | 0 | Allow NULL? |
| 45 | XJUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 46 | XJPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 47 | XJJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 48 | XJUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 49 | XJUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |