COMMON_IDSEQ_3CTRACKING_SEQADMIN_FUNCTIONGROUP_STATUSC=Completed
I=Initiated
CHECKLIST_CDCHECKLIST_SEQA=Active
C=Completed
I=Initiated
N=Notified
O=Ordered
P=Paid Off
R=Received
S=Second Notification
T=Returned
W=Waived
X=Cancelled
CHKLST_360_VW(SQL View) |
Index Back |
|---|
| SELECT A.COMMON_ID , A.SEQ_3C , A.TRACKING_SEQ ,A.INSTITUTION , A.ADMIN_FUNCTION , A.CHECKLIST_STATUS , A.CHECKLIST_CD , B.CHECKLIST_SEQ , B.CHKLST_ITEM_CD , B.ITEM_STATUS ,B.DUE_DT ,A.CHECKLIST_DTTM FROM PS_PERSON_CHECKLST A , PS_PERSON_CHK_ITEM B WHERE A.COMMON_ID = B.COMMON_ID AND A.SEQ_3C = B.SEQ_3C |
| # | 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 |
| 3 | TRACKING_SEQ |
Number(3,0) | SMALLINT NOT NULL | Tracking Sequence |
| 4 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 5 | ADMIN_FUNCTION |
Character(4) | VARCHAR2(4) NOT NULL | Administrative Function |
| 6 | GROUP_STATUS |
Character(1) | VARCHAR2(1) NOT NULL |
Group Status
C=Completed I=Initiated |
| 7 | CHECKLIST_CD |
Character(6) | VARCHAR2(6) NOT NULL | Checklist Code |
| 8 | CHECKLIST_SEQ |
Number(6,0) | INTEGER NOT NULL | Checklist Sequence |
| 9 | CHKLST_ITEM_CD | Character(6) | VARCHAR2(6) NOT NULL | Checklist Item Code |
| 10 | 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 |
| 11 | DUE_DT | Date(10) | DATE | Due Date |
| 12 | CHECKLIST_DTTM | DateTime(26) | TIMESTAMP | Checklist Date Time |