GPIT_RTO_WA_HST(SQL Table) |
Index Back |
---|---|
WA for Retro Changes to ManageThis is the Archive (shadow) table used in Data Archiving for the record: GPIT_RTO_WA. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(8) | VARCHAR2(8) NOT NULL | Archive ID (see PSARCHTEMPLATE). | |
2 | Number(30,0) | DECIMAL(30) NOT NULL | Archive Batch Number | |
3 | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
|
4 | Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id | |
5 | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr | |
6 | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group | |
7 | Character(18) | VARCHAR2(18) NOT NULL | calendar id | |
8 | Character(18) | VARCHAR2(18) NOT NULL | Original Calendar Group ID | |
9 | Number(4,0) | SMALLINT NOT NULL | Result Segment Number | |
10 | Date(10) | DATE | Element Slice End Date | |
11 | Character(3) | VARCHAR2(3) NOT NULL | Company | |
12 | Character(12) | VARCHAR2(12) NOT NULL | INPS Code ITA | |
13 | Number(4,0) | SMALLINT NOT NULL | Year | |
14 | Number(2,0) | SMALLINT NOT NULL | Month | |
15 | Number(4,0) | SMALLINT NOT NULL | Year | |
16 | Number(2,0) | SMALLINT NOT NULL | Month | |
17 | SLICE_BGN_DT | Date(10) | DATE | Element Slice Begin Date |
18 | GPIT_RETRO_TYPE | Character(2) | VARCHAR2(2) NOT NULL | Type |