GVT_SCHEDDEFNVW(SQL View) |
Index Back |
|---|---|
Schedule Definition ViewSchedule Definition View |
| SELECT GVT_SCHED_PREFIX , DESCR , GVT_SUMM_SCHED , RUN_ID , COMPANY , GVT_ECS_RFC_INDIC , GVT_SCHED_STATUS FROM PS_GVT_SCHED_DEFN |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  GVT_SCHED_PREFIX |
Character(10) | VARCHAR2(10) NOT NULL | Schedule Prefix represents user defined part of the Schedule Number. Schedule Number uniquely identifies each schedule and it is combination of Schedule Prefix, Schedule Code and Schedule Sequence. |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | GVT_SUMM_SCHED | Character(1) | VARCHAR2(1) NOT NULL |
Summary Schedule
Y/N Table Edit |
| 4 | RUN_ID | Character(10) | VARCHAR2(10) NOT NULL | Pay Run ID |
| 5 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 6 | GVT_ECS_RFC_INDIC | Character(3) | VARCHAR2(3) NOT NULL |
Regional Finance Center
AFC=Austin Finance Center BFC=Birmingham Finance Center CFC=Chicago Finance Center KFC=Kansas City Finance Center PFC=Philadelphia Finance Center SFC=San Francisco Finance Center Default Value: KFC |
| 7 | GVT_SCHED_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Schedule Process Status
0=Initial 1=Pay Check Data Extracted 2=Schedule Sequence Generated 3=Bulk File Generated 4=SPS File Generated 5=Completed Default Value: 0 |