SCC_3CD_PTMP(SQL Table) |
Index Back |
|---|---|
3CD Policy Manager temp tableUsed to store temporary information regarding the 3C Delete Policy Manager Run Control Deletion Parameters |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 3 | PRM_ID | Number(3,0) | SMALLINT NOT NULL | Parameter ID |
| 4 | SCC_3C_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
3C Type
1=Communication 2=Checklist 3=Comment |
| 5 | SCC_THRESHOLD_DAYS | Number(5,0) | INTEGER NOT NULL | Threshold (days) |
| 6 | ADMIN_FUNCTION | Character(4) | VARCHAR2(4) NOT NULL |
Administrative Function
Prompt Table: SCC_ADM_FCN_VW |
| 7 | COMM_CATEGORY | Character(6) | VARCHAR2(6) NOT NULL |
Communication Category
Prompt Table: COMM_CATG_VW |
| 8 | COMM_CONTEXT | Character(6) | VARCHAR2(6) NOT NULL |
Communication Context
Prompt Table: COMM_CA_CTX_VW |
| 9 | SCC_LETTER_CD | Character(3) | VARCHAR2(3) NOT NULL |
Letter Code
Prompt Table: COMM_CTX_LTR_VW |
| 10 | CHECKLIST_CD | Character(6) | VARCHAR2(6) NOT NULL |
Checklist Code
Prompt Table: CHKLST_SCTY_VW |
| 11 | CHECKLIST_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Checklist Status
C=Completed I=Initiated |
| 12 | CMNT_CATEGORY | Character(6) | VARCHAR2(6) NOT NULL |
Comment Category
Prompt Table: CMNT_CATG_VW |
| 13 | PROCESSED | Character(1) | VARCHAR2(1) NOT NULL |
Processed?
I=In Process N=Not Processed Y=Processed |