Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
PLANCODE | Plan |
String | 16 | View | |
JOBTITLE | Job Title |
String | 8 | View | |
TEMPSEAT | Temporary Seat |
Boolean | 2 | View | |
SEAT | Seat |
Long Integer | 4 | View | |
CHANGEDATE_I | Change Date |
Date | 4 | View | |
SEQ_I | Seq |
Long Integer | 4 | View | |
CHANGETIME_I | Change Time |
Time | 4 | View | |
SEQNUMBR | Sequence Number |
Long Integer | 4 | View | |
EMPLOYID | Employee ID |
String | 16 | View | |
STRTDATE | Start Date |
Date | 4 | View | |
ENDDATE | End Date |
Date | 4 | View | |
ASSIGNMENTSTATUS | Assignment Status |
Integer | 2 | View | |
PRIMARYPOSSEAT | Primary Position/Seat |
Boolean | 2 | View | |
EXPIREDCB | Expired CB |
Boolean | 2 | View | |
INHERITSTATUS | Inheritance Status |
Integer | 2 | View | |
Base_Step_Increased_On | Base Step Increases On |
Integer | 2 | View | |
PYSTPTBLID | Pay Step Table ID |
String | 16 | View | |
Step | Step |
Integer | 2 | View | |
Step_Effective_Date | Step Effective Date |
Date | 4 | View | |
PAYRATEBASEDON | Pay Rate Based On |
Integer | 2 | View | |
PAYRATE | Pay Rate |
Currency | 10 | View | |
CHANGEBY_I | Change By |
String | 16 | View | |
CHANGEREASON_I | Change Reason |
String | 32 | View |