DNP_RUN_CNTL(SQL Table) |
Index Back |
---|---|
DNP File Run ControlRun 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 |