SAD_PDL_RUNCNTL

(SQL Table)
Index Back

Run Control for SAD_PDL_HDR_ST

This is a application run control record for PDL which is used to demonstrate how run control values are passed to processes that run within the process scheduler. This is used to store the Institution values in the SAD_PDL_HDR_STG record.

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

Prompt Table: OPERATOR_VW

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
4 LANGUAGE_OPTION Character(1) VARCHAR2(1) NOT NULL Language Option
O=Specified Language
R=Recipient's Language

Default Value: O

5 SAD_TEMP_TRANS_FLG Character(1) VARCHAR2(1) NOT NULL Check flag for Temporary ID or Transaction code.
C=Transaction Code
I=Temporary ID
6 SCC_TRANSAC_CD Character(25) VARCHAR2(25) NOT NULL Transaction

Prompt Table: SCC_TXN_PROC_VW

7 SAD_FROM_TEMP_ID Number(16,0) DECIMAL(16) NOT NULL From Temporary Constituent ID

Prompt Table: SCC_STGPDLSECVW

8 SAD_TO_TEMP_ID Number(16,0) DECIMAL(16) NOT NULL To Temporary Constituent ID

Prompt Table: SCC_STGPDLSECVW