GVT_PAM_SYS_CTL(SQL Table) |
Index Back |
|---|---|
PAM SPS system controlPAM / SPS system control |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  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 |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | GVT_ECS_PYMNT_1 | Character(1) | VARCHAR2(1) NOT NULL |
Summary Payment Type 1
B=Benefit (SSA, SSI, VA, etc) C=Claim Files D=Daily Benefits (such as PMA) G=Bonds I=IDRS Daily M=Miscellaneous P=Pre Authorized Debit (PAD) S=Salary T=Travel V=Vendor X=Tax Refunds (IMF, BMF) |
| 4 | GVT_ECS_PYMNT_2 | Character(1) | VARCHAR2(1) NOT NULL |
Summary Payment Type 2
C=Checks E=EFT F=FEDLINE/FEDWIRE M=Mixed Check/ACH |
| 5 | GVT_SCHED_MAX_TB | Number(5,0) | INTEGER NOT NULL |
Maximum number of unique TAS BETC combinations per schedule
Default Value: 1000 |
| 6 | GVT_PYMNT_MAX_TB | Number(3,0) | SMALLINT NOT NULL |
Maximum number of unique TAS BETC combinations per payment
Default Value: 100 |
| 7 | GVT_MAX_AMT_TB | Signed Number(15,2) | DECIMAL(13,2) NOT NULL | Maximum amount per one TAS BETC |