GVT_SCHED_PREFIXGVT_SCHED_CODEA=PAMSALCHK
B=PAMSALEFT
C=PAMMISCHK
D=PAMMISEFT
Y/N Table Edit
Y/N Table Edit
GVT_SCHED_GROUP(SQL Table) |
Index Back |
|---|---|
Schedule GroupDefine Schedule Group for Bulk/SPS file |
| # | 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 | GVT_SCHED_CODE |
Character(1) | VARCHAR2(1) NOT NULL |
Schedule Code identifies PeopleSoft supported schedules and it is middle part of the Schedule Number. Schedule Number uniquely identifies each schedule and it is combination of Schedule Prefix, Schedule Code and Schedule Sequence.
A=PAMSALCHK B=PAMSALEFT C=PAMMISCHK D=PAMMISEFT |
| 3 | GVT_SCHED_PROC_IND | Character(1) | VARCHAR2(1) NOT NULL |
Schedule Process Indicator
Y/N Table Edit |
| 4 | GVT_INPUT_SYSTEM | Character(40) | VARCHAR2(40) NOT NULL | Input System (Agency ID + Payment Type 1 + Payment Type 2) |
| 5 | GVT_SCHED_INDC_CHG | Character(1) | VARCHAR2(1) NOT NULL |
Schedule Process Indicator Changed
Y/N Table Edit |