GPSG_NRP_PR3_VW

(SQL View)
Index Back

Runcontrol to store elements

Run Control view to store elements selected to report Payroll component report

SELECT OPRID , RUN_CNTL_ID , PIN_NUM + 50000000 FROM PS_GPSG_RC_ELM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Default Value: PRCSRUNCNTL.OPRID

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

Default Value: PRCSRUNCNTL.RUN_CNTL_ID

3 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

Prompt Table: %GP_EDIT_FLD1