GPUS_EFT_1REC

(SQL Table)
Index Back

EFT 1 Record Type

GP US EFT -- File Header Record for the PPD/CTX file.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 GPUS_REC_TYPE Character(1) VARCHAR2(1) NOT NULL Record Type used in EFT
3 GPUS_PRIORITY_CD Character(2) VARCHAR2(2) NOT NULL Priority Code
4 GPUS_FILLER_1 Character(1) VARCHAR2(1) NOT NULL Filler 1 for GPUS EFT
5 GPUS_BANK_CD Character(9) VARCHAR2(9) NOT NULL 9 char long Bank CD for USA
6 GPUS_EFT_CHAR Character(1) VARCHAR2(1) NOT NULL Char 1 filler
7 FEDERAL_EIN Number(9,0) DECIMAL(9) NOT NULL Federal EIN
8 GPUS_EFT_CREATE_DT Character(6) VARCHAR2(6) NOT NULL File Creation Date
9 GPUS_EFT_CREATE_TM Character(4) VARCHAR2(4) NOT NULL File Creation Time
10 GPUS_FILE_ID Character(1) VARCHAR2(1) NOT NULL File ID Modifier
11 GPUS_REC_SIZE Character(3) VARCHAR2(3) NOT NULL EFT Record Size
12 GPUS_BLOCK_FACTOR Character(2) VARCHAR2(2) NOT NULL Block Factor
13 GPUS_EFT_FMT_CD Character(1) VARCHAR2(1) NOT NULL EFT Format Code
14 GPUS_DEST_BANK_NM Character(23) VARCHAR2(23) NOT NULL Immediate Destination Bank Name
15 GPUS_ORIGIN_NAME Character(23) VARCHAR2(23) NOT NULL Immediate Origin name
16 GPUS_EFT_REF_CD Character(8) VARCHAR2(8) NOT NULL EFT Reference Code