SCC_3CD_POL_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 | PROCESSINSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 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 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTN_SCRTY |
| 6 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 7 | NUM_PARAM_ROWS | Number(10,0) | DECIMAL(10) NOT NULL | Current Row |
| 8 | CURRENT_PARAM_ROW | Number(10,0) | DECIMAL(10) NOT NULL | Current Row |
| 9 | STOP_COUNT | Number(9,0) | DECIMAL(9) NOT NULL | Stop Count |
| 10 | PRM_ID | Number(3,0) | SMALLINT NOT NULL | Parameter ID |
| 11 | SCC_3C_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
3C Type
1=Communication 2=Checklist 3=Comment |
| 12 | SCC_THRESHOLD_DAYS | Number(5,0) | INTEGER NOT NULL | Threshold (days) |
| 13 | ADMIN_FUNCTION | Character(4) | VARCHAR2(4) NOT NULL |
Administrative Function
Prompt Table: SCC_ADM_FCN_VW |
| 14 | COMM_CATEGORY | Character(6) | VARCHAR2(6) NOT NULL |
Communication Category
Prompt Table: COMM_CATG_VW |
| 15 | COMM_CONTEXT | Character(6) | VARCHAR2(6) NOT NULL |
Communication Context
Prompt Table: COMM_CA_CTX_VW |
| 16 | SCC_LETTER_CD | Character(3) | VARCHAR2(3) NOT NULL |
Letter Code
Prompt Table: COMM_CTX_LTR_VW |
| 17 | CHECKLIST_CD | Character(6) | VARCHAR2(6) NOT NULL |
Checklist Code
Prompt Table: CHKLST_SCTY_VW |
| 18 | CHECKLIST_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Checklist Status
C=Completed I=Initiated |
| 19 | CMNT_CATEGORY | Character(6) | VARCHAR2(6) NOT NULL |
Comment Category
Prompt Table: CMNT_CATG_VW |
| 20 | SCC_TOT_COMM_DEL | Number(9,0) | DECIMAL(9) NOT NULL | Total Communications Deleted |
| 21 | SCC_TOT_CMNT_DEL | Number(9,0) | DECIMAL(9) NOT NULL | Total Comments Deleted |
| 22 | SCC_TOT_CHKLST_DEL | Number(9,0) | DECIMAL(9) NOT NULL | Total Checklists Deleted |
| 23 | SCC_TOTAL_DEL_CNT | Number(15,0) | DECIMAL(15) NOT NULL | Total Deleted |
| 24 | SCC_TOTAL_EXCEPTED | Number(15,0) | DECIMAL(15) NOT NULL | Total Excepted |