UPG_FG_AET(SQL Table) |
Index Back |
|---|---|
Federal HR Default State RecorFederal HR Default State Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 4 | SEQ_NO | Number(2,0) | SMALLINT NOT NULL | Sequence Number |
| 5 | TRANS_DT | Date(10) | DATE | Transaction Date |
| 6 | GVT_TRANS_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Transaction Types Translate Values
A=Initial Deposit Amount I=Interest Adjustment S=Scheduled Payment U=Unscheduled Payment |
| 7 | JOB_REQ_NBR | Character(6) | VARCHAR2(6) NOT NULL | Job requisition number |
| 8 | DATETIME_STAMP | DateTime(26) | TIMESTAMP | DateTime Stamp |
| 9 | REQ_DESCR_TYPE | Character(2) | VARCHAR2(2) NOT NULL | Description Type |
| 10 | GVT_RECR_DESCR_CD | Character(3) | VARCHAR2(3) NOT NULL | Description ID |
| 11 | UPG_COUNTER | Number(11,0) | DECIMAL(11) NOT NULL | Row Counter |
| 12 | CITIZENSHIP_STATUS | Character(1) | VARCHAR2(1) NOT NULL | Citizenship Status |
| 13 | NULL_WORK_DATE | Date(10) | DATE | This field is used for the HRMS 8 Upgrade. |
| 14 | NULL_WORK_DTTM | DateTime(26) | TIMESTAMP | Null Work Date Time |
| 15 | DESCRLONG | Long Character | CLOB | Long Description |