GVT_WIP_PROGRAM(SQL Table) |
Index Back |
---|---|
WIP Status Codes Batch Prgms |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | GVT_WIP_RECORD | Character(25) | VARCHAR2(25) NOT NULL | WIP record transaction. |
2 | GVT_PROGRAM | Character(30) | VARCHAR2(30) NOT NULL | Program |
3 | GVT_STATUS_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Status Type
CAN=Cancelled COM=Completed COR=Corrected IRR=IRR Reported WIP=Work-in-progress |
4 | GVT_WIP_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Work-in-Progress Status
Prompt Table: GVT_STS_TYPE_VW |