GPDE_RCTX4LNRVW (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.

GPDE_RCTX4LNRVW

(SQL View)

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 , LANGUAGE_CD , GPDE_RP_HEADING FROM PS_GPDE_RC_TX4_LNG

Parent record: GPDE_RC_PAYROLL

# 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

5 GPDE_RP_HEADING Character(30) VARCHAR2(30) NOT NULL Element Heading

#	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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
5	GPDE_RP_HEADING	Character(30)	VARCHAR2(30) NOT NULL	Element Heading