RETROPAY_RQST(SQL Table) |
Index Back |
|---|---|
Retro Pay RequestRetro Pay Request |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  RETROPAY_SEQ_NO |
Character(8) | VARCHAR2(8) NOT NULL | Retro Pay Sequence Number |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: RETROPAY_RQE_VW |
| 3 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL |
Empl Rcd Nbr
Prompt Table: JOB |
| 4 | RETROPAY_EFFDT |
Date(10) | DATE | Retro Pay Effective Date |
| 5 | RETROPAY_PGM_ID | Character(3) | VARCHAR2(3) NOT NULL |
Retro Pay Program ID
Prompt Table: RETROPAYPGM_TBL |
| 6 | RETROPAY_RQST_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Retro Pay Request Type
A=Additional Pay Request J=Job Related Request M=Mass Retro Pay Request |
| 7 | PRCS_END_DT | Date(10) | DATE | Process End Date |
| 8 | MASS_RETRO_RQST_ID | Character(5) | VARCHAR2(5) NOT NULL |
Mass Retro Request ID
Prompt Table: MASS_RETRO_RQST |
| 9 | RETRO_COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Retro Pay Company
Prompt Table: COMPANY_TBL |
| 10 | RETRO_PAYGROUP | Character(3) | VARCHAR2(3) NOT NULL |
Retro Pay Paygroup
Prompt Table: PAYGROUP_TBL |
| 11 | RETRO_PAY_END_DT | Date(10) | DATE | Retro Pay - Pay End Date |
| 12 | RETRO_OFF_CYCLE | Character(1) | VARCHAR2(1) NOT NULL |
Retro Pay Off Cycle
Y/N Table Edit Default Value: N |
| 13 | RETRO_PAGE_NO | Number(4,0) | SMALLINT NOT NULL | Retro Pay Page Number |
| 14 | RETRO_LINE_NO | Number(3,0) | SMALLINT NOT NULL | Retro Pay Line Number |
| 15 | RETROPAY_PRCS_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Retro Pay Process Flag
C=Calculated N=Not Processed P=Loaded to Paysheets R=Recalculate Request X=Extracted Default Value: N |
| 16 | DUPLICATE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Duplicate Flag
Y/N Table Edit Default Value: N |
| 17 | PROC_DTTMSTAMP | DateTime(26) | TIMESTAMP | Process Date Timestamp |
| 18 | ELIG_FOR_INTEREST | Character(1) | VARCHAR2(1) NOT NULL |
Eligible for Retropay Interest Flag
Y/N Table Edit |
| 19 | PRIOR_SHIFT | Character(1) | VARCHAR2(1) NOT NULL | Prior Shift |