ENGINE_3C_AET(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | COMMON_ID | Character(11) | VARCHAR2(11) NOT NULL | Common ID to store Personal ID / Ext Org ID value |
| 3 | SCCPS_POP_SEL | Character(1) | VARCHAR2(1) NOT NULL |
Population Selection checkbox - used to incidate on run controls that pop selection was selected for use.
Y/N Table Edit Default Value: Y |
| 4 | SCCPS_TOOL_ID | Number(15,0) | DECIMAL(15) NOT NULL |
Tool ID - the unique key for a pop select tool
Prompt Table: SCCPS_TOOL_VW |
| 5 | SCCPS_QUERY_NAME | Character(50) | VARCHAR2(50) NOT NULL |
Query / Section name used by population selection
Prompt Table: %EDITTABLE |
| 6 | SCCPS_CNTXT_ID | Number(15,0) | DECIMAL(15) NOT NULL |
Context ID - the unique key that identifies the pop selection context
Prompt Table: SCCPS_CNTXT_VW |
| 7 | ATTACHSYSFILENAME | Character(128) | VARCHAR2(128) NOT NULL | Unique Sys Filename |
| 8 | ATTACHUSERFILE | Character(64) | VARCHAR2(64) NOT NULL | Attached File |
| 9 | SCCPS_FILE_PATH | Character(254) | VARCHAR2(254) NOT NULL | Pop Select File Path and Name |
| 10 | SEQ_3C | Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 11 | SA_ID_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
ID Type
O=Organization P=Person |
| 12 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
| 13 | EVENT_3CS_ID | Character(10) | VARCHAR2(10) NOT NULL | 3Cs event ID |
| 14 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 15 | ADMIN_FUNCTION | Character(4) | VARCHAR2(4) NOT NULL | Administrative Function |
| 16 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 17 | EXIST | Character(1) | VARCHAR2(1) NOT NULL | Currency Exist |
| 18 | DUE_DT | Date(10) | DATE | Expected Birth Date |
| 19 | DUP_CHECK | Character(1) | VARCHAR2(1) NOT NULL | Duplicate Keys Check |
| 20 | DUPCOMM_COMPL_COND | Character(1) | VARCHAR2(1) NOT NULL |
Communication Status
N=Not Completed Y=Completed |
| 21 | DUPCOMM_VDATA_COND | Character(1) | VARCHAR2(1) NOT NULL |
Variable Data
N=Do Not Match Y=Match |
| 22 | DUE_DAYS | Number(3,0) | SMALLINT NOT NULL | Due Days |
| 23 | CHECKLIST_CD | Character(6) | VARCHAR2(6) NOT NULL | Checklist Code |
| 24 | CHECKLIST_SEQ | Number(6,0) | INTEGER NOT NULL | Checklist Sequence |
| 25 | CMNT_CATEGORY | Character(6) | VARCHAR2(6) NOT NULL | Comment Category |
| 26 | COMM_KEY | Character(8) | VARCHAR2(8) NOT NULL | Communication Speed Key |
| 27 | SEQNO | Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 28 | CHKLST_ITEM_CD | Character(6) | VARCHAR2(6) NOT NULL | Checklist Item Code |
| 29 | ITEM_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Item Status
A=Active C=Completed I=Initiated N=Notified O=Ordered P=Paid Off R=Received S=Second Notification T=Returned W=Waived X=Cancelled |
| 30 | TRACKING_GROUP | Character(6) | VARCHAR2(6) NOT NULL | Tracking Group |
| 31 | VAR_DATA_SEQ | Number(4,0) | SMALLINT NOT NULL | Variable Data Sequence Number |
| 32 | TRACKING_SEQ | Number(3,0) | SMALLINT NOT NULL | Tracking Sequence |
| 33 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 34 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 35 | SQL_TEXT1 | Character(254) | VARCHAR2(254) NOT NULL | SQL Text 1 |
| 36 | SQL_TEXT2 | Character(254) | VARCHAR2(254) NOT NULL | SQL Text 2 |
| 37 | MC_DEFN_ID | Character(30) | VARCHAR2(30) NOT NULL | Mass Change Definition |
| 38 | MC_GROUP_ID | Character(30) | VARCHAR2(30) NOT NULL | Mass Change Group ID |
| 39 | PROCESS_JOINT | Character(1) | VARCHAR2(1) NOT NULL |
Used by the Run_Cntl_3CEng page to capture run control parameters for the 3C Engine to branch off and call the Joint Rules Engine.
A=Yes, all Joint IDs B=Yes, if match exists N=No Joint Processing |
| 40 | COMM_COMMENTS | Long Character(2000) | VARCHAR2(2000) | Communication Comments |
| 41 | DUPCHK_COMPL_COND | Character(1) | VARCHAR2(1) NOT NULL |
Checklist Status
C=Completed I=Initiated |
| 42 | DUPCHK_VDATA_COND | Character(1) | VARCHAR2(1) NOT NULL |
Variable Data
N=Do Not Match Y=Match |
| 43 | DUP_CHKLST_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Duplicate Checklist Check |
| 44 | COUNT_RESULT | Character(6) | VARCHAR2(6) NOT NULL | Count |
| 45 | COMMENT_PRINT_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Print Comments for Communications |