| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Default Value: INSTALLATION.COMPANY
Prompt Table:
COMPANY_TBL
|
| 2 |
GVT_SCHEDULE_NO |
Character(14) |
VARCHAR2(14) NOT NULL |
Schedule Number
|
| 3 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 4 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
| 5 |
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: AFC
|
| 6 |
OFF_CYCLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Off Cycle ?
Y/N Table Edit
Default Value: N
|
| 7 |
GVT_ECS_NET_ONLY |
Character(1) |
VARCHAR2(1) NOT NULL |
GVT ECS Net Pay Only Extract
Y/N Table Edit
Default Value: N
|
| 8 |
GVT_ECS_DOS_NAME |
Character(8) |
VARCHAR2(8) NOT NULL |
DOS File Name
|
| 9 |
GVT_ECS_DOS_EXT |
Character(3) |
VARCHAR2(3) NOT NULL |
DOS File Extension
|
| 10 |
GVT_ECS_TRANS_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
GVT ECS Transaction Type
01=Vendor Check Payments Schedule
02=Vendor ACH Payment Schedule
03=Salary ACH Payment Schedule
04=Travel ACH Payment Schedule
05=Summary Schedule
06=SDPR Schedule
07=Misc. Check Payment Schedule
08=Misc ACH Payment Schedule
Default Value: 05
|
| 11 |
GVT_ECS_GEN_DT |
Date(10) |
DATE |
ECS Transmission Generation Dt
|
| 12 |
GVT_ECS_EXTRACT_DT |
Date(10) |
DATE |
ECS Transmission Extract Dt
|
| 13 |
GVT_ECS_REQ_PAY_DT |
Date(10) |
DATE |
Requested Payment Date
|
| 14 |
GVT_ECS_NO_OF_PMNT |
Number(8,0) |
INTEGER NOT NULL |
Number of Payments in Schedule
|
| 15 |
GVT_ECS_TOT_AMT |
Number(15,2) |
DECIMAL(14,2) NOT NULL |
Schedule Total Amount
|
| 16 |
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)
|
| 17 |
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
|
| 18 |
GVT_ECS_PRENOTE_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Prenotification Schedule ?
|
| 19 |
GVT_ECS_MAC_DATA |
Character(8) |
VARCHAR2(8) NOT NULL |
MAC Payment Data
|