DNP_FILE_AET

(SQL Table)
Index Back

Default AET for DNP_SUP_FILE

Default AET used in DNP_SUP_FILE application engine.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID
5 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

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

Prompt Table: AGENCY_LOC_CD

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

Default Value: B

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

Default Value: W

11 DNP_ACCS_GRP Character(25) VARCHAR2(25) NOT NULL Do Not Pay Access Group
12 DNP_BEGIN_DT Character(10) VARCHAR2(10) NOT NULL Begin Date
13 DNP_END_DT Character(10) VARCHAR2(10) NOT NULL End Date
14 DNP_EXP_CD_NAME Character(15) VARCHAR2(15) NOT NULL File Expected Use Code
15 DNP_FREQ_NAME Character(15) VARCHAR2(15) NOT NULL Monitoring Frequency Name
16 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
17 FLAG1 Character(1) VARCHAR2(1) NOT NULL Flag1
18 FLAG2 Character(1) VARCHAR2(1) NOT NULL Flag2
19 COUNT_LINES Number(15,0) DECIMAL(15) NOT NULL Count of Lines
20 DNP_AG_LOC_CD Character(8) VARCHAR2(8) NOT NULL Agency Location Code
21 FLAG3 Character(1) VARCHAR2(1) NOT NULL Flag3