RUN_AP_CCR_LOAD

(SQL Table)
Index Back

CCR Run Control 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).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 REQUEST_NBR Number(4,0) SMALLINT NOT NULL Request Number
4 SOURCE_SYSTEM Character(3) VARCHAR2(3) NOT NULL Source System
CCR=CCR
EBL=eBill Contact Maintenance
FED=FED
PEN=Pension Customer

Default Value: CCR

5 PROCESSED_FLG Character(1) VARCHAR2(1) NOT NULL Plan Processed Flag
C=Complete
E=Errors
N=Initialize
P=In Process

Default Value: N

6 FILE_NAME Character(80) VARCHAR2(80) NOT NULL File Name
7 PATHNAME Character(254) VARCHAR2(254) NOT NULL PATHNAME
8 FILE_PATH_NAME Character(254) VARCHAR2(254) NOT NULL File Path
9 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
10 CCR_ORDER_FLG Character(1) VARCHAR2(1) NOT NULL Disable Ordering for Expired

Y/N Table Edit

Default Value: N

11 CCR_UPDT_VCH Character(1) VARCHAR2(1) NOT NULL Update CCR Vouchers On Hold

Y/N Table Edit

Default Value: N