RETROPAY_RQS_VW

(SQL View)
 Index Back

Retro Pay Request View

Retro Pay Request View

SELECT retropay_seq_no , emplid , EMPL_RCD , retropay_effdt , retropay_pgm_id , retropay_rqst_type , prcs_end_dt , mass_retro_rqst_id , retro_company , retro_paygroup , retro_pay_end_dt , retro_off_cycle , retro_page_no , retro_line_no , retropay_prcs_flag , duplicate_flag , proc_dttmstamp FROM PS_RETROPAY_RQST WHERE retropay_prcs_flag IN ('C','P','F','A','V','M')

# 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: PERSONAL_DTA_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 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
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(5,0) INTEGER 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 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

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