RETROPAY_RQST

(SQL Table)
Index Back

Retro Pay Request

Retro Pay Request

  • Parent Record Of RETROPAY_TRGDTL
  • # 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