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
CHECKLST_DTL_VW(SQL View) |
Index Back |
|---|
| SELECT A.COMMON_ID , A.SEQ_3C , A.TRACKING_SEQ , A.ADMIN_FUNCTION , A.GROUP_STATUS , A.CHECKLIST_CD , B.CHECKLIST_SEQ , B.CHKLST_ITEM_CD , B.ITEM_STATUS FROM PS_CHECKLST_VW 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 | ADMIN_FUNCTION |
Character(4) | VARCHAR2(4) NOT NULL | Administrative Function |
| 5 | GROUP_STATUS |
Character(1) | VARCHAR2(1) NOT NULL |
Group Status
C=Completed I=Initiated |
| 6 | CHECKLIST_CD |
Character(6) | VARCHAR2(6) NOT NULL | Checklist Code |
| 7 | CHECKLIST_SEQ |
Number(6,0) | INTEGER NOT NULL | Checklist Sequence |
| 8 | CHKLST_ITEM_CD | Character(6) | VARCHAR2(6) NOT NULL | Checklist Item Code |
| 9 | 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 |