GPDE_RCTX4_NRVW

(SQL View)
 Index Back

Run Control Pay Advice

RUN_CNTL_PADV_P contains all paygroups that are used as input parameters for the Payadvice Report. Input data is retrieved from this record when a report is requested from the Process Scheduler.

SELECT OPRID , RUN_CNTL_ID , PIN_NUM + 50000000 , GPDE_AL_OVERRIDE , GPDE_RP_HEADING , GPDE_AL_SEQNUM FROM PS_GPDE_RC_TX04

  • Related Language Record: GPDE_RC_TX4_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

    Prompt Table: GP_PIN_AC0_VW

    4 GPDE_AL_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Override Indicator

    Y/N Table Edit

    Default Value: N

    5 GPDE_RP_HEADING Character(30) VARCHAR2(30) NOT NULL Element Heading
    6 GPDE_AL_SEQNUM Number(3,0) SMALLINT NOT NULL Sequence