COMMON_IDSEQ_3CCHKLST_ITEM_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
Default Value: I
PERS_CHKLST1_VW(SQL View) |
Index Back |
|---|---|
Person Checklist Update View 1PERS_CHKLST1_VW is used as the main view for rapid data entry in updating checklist status and status date for a person. |
| SELECT COMMON_ID ,SEQ_3C , CHKLST_ITEM_CD , CHECKLIST_SEQ , ITEM_STATUS , STATUS_DT FROM PS_PERSON_CHK_ITEM WHERE Item_Status NOT IN ('C','W') |
| # | 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 | CHKLST_ITEM_CD |
Character(6) | VARCHAR2(6) NOT NULL | Checklist Item Code |
| 4 | CHECKLIST_SEQ |
Number(6,0) | INTEGER NOT NULL | Checklist Sequence |
| 5 | 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 Default Value: I |
| 6 | STATUS_DT | Date(10) | DATE NOT NULL | Status Date |