DNP_RUN_CNTL

(SQL Table)
Index Back

DNP File Run Control

Run control for DNP_SUP_FILE AE.

# 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 REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID
4 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

5 ALC Character(8) VARCHAR2(8) NOT NULL Agency Location Code

Prompt Table: AGENCY_LOC_CD

6 DNP_FILE_NAME Character(8) VARCHAR2(8) NOT NULL Do Not Pay File Name
7 DNP_FILE_EXP_CD Character(1) VARCHAR2(1) NOT NULL File Expected Use Code
B=BATCH MATCH
C=CONTINUOUS

Default Value: C

8 DNP_CONT_FREQ Character(1) VARCHAR2(1) NOT NULL Monitoring Frequency
D=DAILY
M=MONTHLY
W=WEEKLY

Default Value: W