GVT_SCHEDULE_NOPrompt Table: GVT_ECS_CONTROL
GVT_ECS_OFFC_VW(SQL View) |
Index Back |
|---|---|
GVT ECS Off Cycle View 4Used to track the assigning and usage of the ECS Schedule Numbers. |
| SELECT A.GVT_SCHEDULE_NO FROM PS_GVT_ECS_CONTROL A WHERE A.GVT_ECS_TRANS_TYPE IN ('07') AND A.OFF_CYCLE ='Y' AND A.GVT_ECS_DOS_NAME = ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GVT_SCHEDULE_NO |
Character(14) | VARCHAR2(14) NOT NULL |
Schedule Number
Prompt Table: GVT_ECS_CONTROL |