GFAP_ECS_SUM

(SQL Table)
Index Back

Federal ECS Summary

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
2 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
3 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank
4 SCHEDULE_ID Character(10) VARCHAR2(10) NOT NULL Schedule ID

Prompt Table: GFAP_ECS_SCH_VW

5 GFAP_ECS_SUM_PAY1 Character(1) VARCHAR2(1) NOT NULL Summary Payment Type 1
B=Benefit
C=Claims File
D=Daily Benefits
G=Bonds
I=IDRS Daily
M=Miscellaneous
P=Pre-Authorized Debit
S=Salary
T=Travel
V=Supplier
X=Tax Refunds
6 GFAP_ECS_SUM_PAY2 Character(1) VARCHAR2(1) NOT NULL Summary Payment Type 2
C=Check
E=Electronic File Transfer
F=Fedline/Fedwire
M=Mixed Check/ACH
7 RFC_CODE Character(3) VARCHAR2(3) NOT NULL Regional Financial Center

Prompt Table: RFC_CODE_TBL
Set Control Field: BANK_SETID

8 GFAP_ECS_MAC_CODE Character(8) VARCHAR2(8) NOT NULL MAC for Payment Type
9 PROCESS_COMPLETE Character(1) VARCHAR2(1) NOT NULL Process Complete

Y/N Table Edit

Default Value: N

10 PYMNT_DT Date(10) DATE NOT NULL Payment Date
11 GFAP_ECS_TAPE_1 Character(7) VARCHAR2(7) NOT NULL Reel 1
12 GFAP_ECS_TAPE_2 Character(7) VARCHAR2(7) NOT NULL Reel 2
13 GFAP_ECS_TAPE_3 Character(7) VARCHAR2(7) NOT NULL Reel 3
14 GFAP_ECS_TAPE_4 Character(7) VARCHAR2(7) NOT NULL Reel 4
15 GFAP_ECS_TAPE_5 Character(7) VARCHAR2(7) NOT NULL Reel 5
16 COMMENTS_254 Character(254) VARCHAR2(254) NOT NULL EDI Comments