PERSON_CHECKLST(SQL Table) |
Index Back |
|---|---|
Person ChecklistPERSON_CHECKLST is used to create a list of requirements, communication, staff assignments, etc. relative to a person. There is one record in this table for each dated list. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  COMMON_ID |
Character(11) | VARCHAR2(11) NOT NULL | Common ID to store Personal ID / Ext Org ID value |
| 2 | SEQ_3C |
Number(5,0) | INTEGER NOT NULL |
Sequence Number
Default Value: 99999 |
| 3 | SA_ID_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
ID Type
O=Organization P=Person |
| 4 | CHECKLIST_DTTM | DateTime(26) | TIMESTAMP NOT NULL |
Checklist Date Time
Default Value: %date |
| 5 | ADMIN_FUNCTION | Character(4) | VARCHAR2(4) NOT NULL |
Administrative Function
Prompt Table: %EDITTABLE15 |
| 6 | CHECKLIST_CD | Character(6) | VARCHAR2(6) NOT NULL |
Checklist Code
Prompt Table: CHKLST_SCTY_VW |
| 7 | CHECKLIST_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Checklist Status
C=Completed I=Initiated Default Value: I |
| 8 | STATUS_DT | Date(10) | DATE |
Status Date
Default Value: %date |
| 9 | STATUS_CHANGE_ID | Character(11) | VARCHAR2(11) NOT NULL |
Status Change ID
Prompt Table: PEOPLE_SRCH |
| 10 | DUE_DT | Date(10) | DATE | Due Date |
| 11 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 12 | DUE_AMT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Due Amount |
| 13 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Default Value: OPR_DEF_TBL_CS.DEPTID Prompt Table: DEPT_TBL |
| 14 | RESPONSIBLE_ID | Character(11) | VARCHAR2(11) NOT NULL |
Responsible ID
Default Value: PERSON_CHECKLST.STATUS_CHANGE_ID Prompt Table: PEOPLE_SRCH |
| 15 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
| 16 | TRACKING_SEQ | Number(3,0) | SMALLINT NOT NULL | Tracking Sequence |
| 17 | ORG_CONTACT | Number(4,0) | SMALLINT NOT NULL | Contact Nbr |
| 18 | CONTACT_NAME | Character(50) | VARCHAR2(50) NOT NULL | Contact Name |
| 19 | VAR_DATA_SEQ | Number(4,0) | SMALLINT NOT NULL | Variable Data Sequence Number |
| 20 | COMM_COMMENTS | Long Character(2000) | VARCHAR2(2000) | Communication Comments |