| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 CAMPUS_EVENT_NBR |
Character(9) |
VARCHAR2(9) NOT NULL |
Event ID
Prompt Table:
CAMPUS_EVENT
|
| 2 |
CHECKLIST_DTTM |
DateTime(26) |
TIMESTAMP NOT NULL |
Checklist Date Time
Default Value: CAMPUS_EVNT_CHK.CHECKLIST_DTTM
Prompt Table:
CAMPUS_EVNT_CHK
|
| 3 |
CHECKLIST_SEQ |
Number(6,0) |
INTEGER NOT NULL |
Checklist Sequence
|
| 4 |
CHKLST_ITEM_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Checklist Item Code
Prompt Table:
EVE_CHKITEM_VW
|
| 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
Default Value: CAMPUS_EVNT_CHK.STATUS_DT
|
| 7 |
STATUS_CHANGE_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Status Change ID
Default Value: CAMPUS_EVNT_CHK.STATUS_CHANGE_ID
Prompt Table:
PEOPLE_SRCH
|
| 8 |
DUE_DT |
Date(10) |
DATE NOT NULL |
Due Date
|
| 9 |
RESPONSIBLE_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Responsible ID
Default Value: CAMPUS_CHK_ITEM.STATUS_CHANGE_ID
Prompt Table:
PEOPLE_SRCH
|