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(15) | VARCHAR2(15) 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 Record
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 | RETRO_TRG_PGM_ID | Character(3) | VARCHAR2(3) NOT NULL |
This field will define the Retroactive Program ID.
Prompt Table: PY_RETROTRG_DEF |
7 | RETROPAY_RQST_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
If translate values are added/modified for RETROPAY_RQST_TYPE field, same changes must be done for RETROPAY_RQST_TYP1 field.
A=Additional Pay Request J=Job Related Request M=Mass Retro Pay Request |
8 | PRCS_END_DT | Date(10) | DATE | Process End Date |
9 | MASS_RETRO_RQST_ID | Character(5) | VARCHAR2(5) NOT NULL |
Mass Retro Request ID
Prompt Table: MASS_RETRO_RQST |
10 | RETRO_COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Retro Pay Company
Prompt Table: COMPANY_TBL |
11 | RETRO_PAYGROUP | Character(3) | VARCHAR2(3) NOT NULL |
Retro Pay Paygroup
Prompt Table: PAYGROUP_TBL |
12 | RETRO_PAY_END_DT | Date(10) | DATE | Retro Pay - Pay End Date |
13 | RETRO_OFF_CYCLE | Character(1) | VARCHAR2(1) NOT NULL |
Retro Pay Off Cycle
Y/N Table Edit Default Value: N |
14 | RETRO_PAGE_NO | Number(5,0) | INTEGER NOT NULL | Retro Pay Page Number |
15 | RETRO_LINE_NO | Number(3,0) | SMALLINT NOT NULL | Retro Pay Line Number |
16 | RETROPAY_PRCS_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
If translate values are added/modified for RETROPAY_PRCS_FLAG field, same changes must be done for RETROPAY_PRCS_FLG1 field.
A=Action Required C=Calculated F=Confirmed Payment M=Manually Loaded to Paysheet N=Not Processed P=Loaded to Paysheets R=Recalculate Request S=Suspended V=Paycheck Reversed W=Cancelled / Withdrawn X=Extracted Default Value: N |
17 | RETRO_CANC_REASON | Character(2) | VARCHAR2(2) NOT NULL |
Reason for cancelling the Retro Request.
Prompt Table: CANC_REASON_DVW |
18 | DUPLICATE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Duplicate Flag
Y/N Table Edit Default Value: N |
19 | PROC_DTTMSTAMP | DateTime(26) | TIMESTAMP | Process Date Timestamp |
20 | ELIG_FOR_INTEREST | Character(1) | VARCHAR2(1) NOT NULL |
Eligible for Retropay Interest Flag
Y/N Table Edit |
21 | PRIOR_SHIFT | Character(1) | VARCHAR2(1) NOT NULL | Prior Shift |