GVT_WIP_RECORDGVT_WIP_STATUSCAN=Cancelled
COM=Completed
COR=Corrected
IRR=IRR Reported
WIP=Work-in-progress
Default Value: WIP
GVT_WIP_STA_VW3(SQL View) |
Index Back |
|---|---|
WIP Status View 3This if for the CPDF Dynamic Select Process. |
| SELECT GVT_WIP_RECORD, GVT_WIP_STATUS, DESCRSHORT, GVT_STATUS_TYPE FROM PS_GVT_WIP_STATUS |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GVT_WIP_RECORD |
Character(25) | VARCHAR2(25) NOT NULL | Transaction |
| 2 | GVT_WIP_STATUS |
Character(3) | VARCHAR2(3) NOT NULL | Work-in-Progress Status |
| 3 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 4 | GVT_STATUS_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Status Type
CAN=Cancelled COM=Completed COR=Corrected IRR=IRR Reported WIP=Work-in-progress Default Value: WIP |