PROCESS_INSTANCECCR=CCR
EBL=eBill Contact Maintenance
FED=FED
PEN=Pension Customer
Default Value: CCR
N=No
Y=Yes
N=No
Y=Yes
E=Error
I=In Process
L=Loaded
M=Loaded with Error
AP_CCR_AET(SQL Table) |
Index Back |
|---|---|
CCR Load State Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | SOURCE_SYSTEM | Character(3) | VARCHAR2(3) NOT NULL |
Source System
CCR=CCR EBL=eBill Contact Maintenance FED=FED PEN=Pension Customer Default Value: CCR |
| 3 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 4 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 5 | REQUEST_NBR | Number(4,0) | SMALLINT NOT NULL | Request Number |
| 6 | AE_APPSTATUS | Number(1,0) | SMALLINT NOT NULL | AE Application Warning Status |
| 7 | FILE_NAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
| 8 | FILE_PATH_NAME | Character(254) | VARCHAR2(254) NOT NULL | File Path |
| 9 | INCREMENTAL_SW | Character(1) | VARCHAR2(1) NOT NULL |
Identifies whether a same day statement is an incremental statement or not.
N=No Y=Yes |
| 10 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 11 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 12 | COUNT_1 | Number(3,0) | SMALLINT NOT NULL | Count Work Field |
| 13 | COUNT_2 | Number(3,0) | SMALLINT NOT NULL | Count Work Field |
| 14 | COUNT_3 | Number(3,0) | SMALLINT NOT NULL | Count Work Field |
| 15 | SEQUENCENO | Number(10,0) | DECIMAL(10) NOT NULL | Sequence Number |
| 16 | DATETIME_STAMP | DateTime(26) | TIMESTAMP | DateTime Stamp |
| 17 | SELECT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Selection Flag
N=No Y=Yes |
| 18 | DUNS_NUMBER | Character(9) | VARCHAR2(9) NOT NULL | DUNS Number |
| 19 | CCR_DUNS_PLUS4 | Character(4) | VARCHAR2(4) NOT NULL | DUNS Suffix |
| 20 | CCR_ORDER_FLG | Character(1) | VARCHAR2(1) NOT NULL | Disable Ordering for Expired |
| 21 | CCR_UPDT_VCH | Character(1) | VARCHAR2(1) NOT NULL | Update CCR Vouchers On Hold |
| 22 | CCR_FILE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
File Status
E=Error I=In Process L=Loaded M=Loaded with Error |
| 23 | CCR_SIC_FLG | Character(1) | VARCHAR2(1) NOT NULL | Use SIC code functionality flag |
| 24 | CCR_NAICS_FLG | Character(1) | VARCHAR2(1) NOT NULL | Use delivered NAICS code functionality flag |
| 25 | SQLTEXT | Long Character(14000) | CLOB | SQL Statement Text |
| 26 | SQL_SELECT_001 | Character(254) | VARCHAR2(254) NOT NULL | |
| 27 | FILE_CREATE_DT | Date(10) | DATE | File Creation Date |
| 28 | AE_APPLID | Character(12) | VARCHAR2(12) NOT NULL | Program Name (see PSAEAPPLDEFN). |
| 29 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |