GPAU_EFT_CX_AET (SQL Table)	Index Back
EFT process State record for electronic funds transfer process

GPAU_EFT_CX_AET

(SQL Table)

EFT process

State record for electronic funds transfer process

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 GPAU_BANK_DB_TYPE Character(2) VARCHAR2(2) NOT NULL This field distinguishes debit types and is used in the AE program GPAU_EFT_CMX.
10=Group Tax
20=Net Payment
30=Recipient

3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

4 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

5 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

6 STRM_NUM Number(4,0) SMALLINT NOT NULL Stream Number

7 EMPLID_FROM Character(11) VARCHAR2(11) NOT NULL EMPLID (first for a range)

8 EMPLID_TO Character(11) VARCHAR2(11) NOT NULL Empl ID To

9 GPAU_PMT_TYPE Character(2) VARCHAR2(2) NOT NULL This field allows the user to decide what kind of processing will occurr in the AE program GPAU_EFT_CMX.
10=Net Pay Distribution Only
20=Recipient Deduction Only
30=Net Pay And Recipient
40=Group Tax

10 GPAU_RCPNT_OPTN Character(2) VARCHAR2(2) NOT NULL This is used to identify the recipient option.
10=Select Recipients Only
20=All Recipients
30=Deduction

11 GPAU_RCP_CAL_OPTN Character(2) VARCHAR2(2) NOT NULL This field is used to identify the calculation option to use.
10=Recipient ID
20=All Recipients
30=Deduction

12 PAYMENT_DT Date(10) DATE Payment Date

13 RECIPIENT_ID Character(8) VARCHAR2(8) NOT NULL Payment recipient ID

14 RECIPIENT_TAG Number(3,0) SMALLINT NOT NULL Used to identify recipients for E/D, PI

15 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

16 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity

17 ORG_LINK_OPTN Character(2) VARCHAR2(2) NOT NULL Identifies at what org level source banks are assigned. Value set at this time: Company, Dept, Location, Pay Entity, Pay Group
CO=Company
DE=Department
ET=Establishment
LO=Location
PG=Pay Group

18 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

19 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

20 GP_PMT_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount field on GP PAYMENT table

21 GPAU_EFT_PMT_AMT Character(10) VARCHAR2(10) NOT NULL This field tracks the Payment Amount in a specific character formatted format for the AE program GPAU_EFT_CMX.

22 GPAU_EFT_USER_NO Character(6) VARCHAR2(6) NOT NULL EFT User Number used in the AE program GPAU_EFT_CMX.

23 GPAU_USER_NO Character(6) VARCHAR2(6) NOT NULL EFT User Number used in the AE program GPAU_EFT_CMX.

24 ACCOUNT_NAME Character(50) VARCHAR2(50) NOT NULL Account Name

25 DESCR Character(30) VARCHAR2(30) NOT NULL Description

26 GPAU_TR_ACCOUNT_CD Character(35) VARCHAR2(35) NOT NULL The Trace Account Code supersedes any account code tracked on the Source Bank Table.

27 GPAU_TR_BRANCH_CD Character(17) VARCHAR2(17) NOT NULL The Trace Branch Code supersedes any Branch Code tracked on the Source Bank Table.

28 GPAU_LODGEMENT_REF Character(50) VARCHAR2(50) NOT NULL This field is used in the AE program GPAU_EFT_CMX.

29 GPAU_PROC_STREAMS Character(1) VARCHAR2(1) NOT NULL This field is used for processing streams.

30 GPAU_ENTRY_DESCR Character(12) VARCHAR2(12) NOT NULL This is the entry description used for CEMTEX processing.

31 GPAU_EFT_TT_NET Character(10) VARCHAR2(10) NOT NULL This field tracks the Net Amount in a specific format for the file generated by the AE program GPAU_EFT_CMX.

32 GPAU_EFT_TT_CR Character(10) VARCHAR2(10) NOT NULL This field tracks the Credit Amount in a specific format for the file generated by the AE program GPAU_EFT_CMX.

33 GPAU_EFT_TT_DB Character(10) VARCHAR2(10) NOT NULL This field tracks the Debit Amount in a specific format for the file generated by the AE program GPAU_EFT_CMX.

34 GPAU_EFT_TT_REC Character(6) VARCHAR2(6) NOT NULL This field tracks the total number of records in a specific format for the file generated by the AE program GPAU_EFT_CMX.

35 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number

36 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

37 GPAU_CMX_SEQ_NO Character(2) VARCHAR2(2) NOT NULL This is the Cemtex Seq No.

38 BANK_CD Character(11) VARCHAR2(11) NOT NULL Bank ID

39 ERROR_TYPE Character(3) VARCHAR2(3) NOT NULL Error Type
ERR=Stop
NON=None
WAR=Warning

40 ERROR_CNT Number(4,0) SMALLINT NOT NULL Error Count

41 SRC_BANK_ID Character(8) VARCHAR2(8) NOT NULL Source Bank ID

42 GPAU_EFT_TRANS_CD Character(2) VARCHAR2(2) NOT NULL This field tracks 3 values used in the output file for the AE program GPAU_EFT_CMX.
13=Debit
50=Recipient Credit
53=Payroll Credit

43 EMPLID_PAYEE Character(11) VARCHAR2(11) NOT NULL Payee Empl ID

44 EMPL_RCD_PAYEE Number(3,0) SMALLINT NOT NULL Employment Record for Payee

45 PIN_NUM_LAST Number(8,0) INTEGER NOT NULL Last Used Element Number

46 DEBIT_DT Date(10) DATE Debit Date

47 BRANCH_EC_CD Character(17) VARCHAR2(17) NOT NULL Bank Branch ID

48 ACCOUNT_EC_ID Character(35) VARCHAR2(35) NOT NULL Account Number used in banking.

49 INSTANCE Number(3,0) SMALLINT NOT NULL Instance Number

50 GPAU_RCP_COMM_AMT Number(9,2) DECIMAL(8,2) NOT NULL The Commission Amount is the percentage or flatamount deducted from the payments given to a recipient.

51 GPAU_RCP_COMM_OPTN Character(2) VARCHAR2(2) NOT NULL This is used to identify whether to calculate commission amounts or not.
10=Deduct Commission
20=Report Only
30=None

52 GPAU_RCP_COMM_TYPE Character(2) VARCHAR2(2) NOT NULL The commission type determines if a payment amount is reduced when paying a recipient.
10=Flat Amount
20=Percentage
30=None

53 GPAU_EFT_NET Number(18,2) DECIMAL(17,2) NOT NULL This field tracks the net amount (credit-debit) for the AE program GPAU_EFT_CMX.

54 GPAU_EFT_CR Signed Number(19,2) DECIMAL(17,2) NOT NULL This field tracks the credit amount for the AE program GPAU_EFT_CMX.

55 GPAU_EFT_DB Signed Number(19,2) DECIMAL(17,2) NOT NULL This field tracks the debit amount for the AE program GPAU_EFT_CMX.

56 GPAU_EFT_REC Number(6,0) INTEGER NOT NULL This tracks the number of records processed in the AE program GPAU_EFT_CMX.

57 DESCR15 Character(15) VARCHAR2(15) NOT NULL Short Description

58 PRD_BGN_DT Date(10) DATE Period Begin Date

59 PRD_END_DT Date(10) DATE Pay Period End Date

60 GPAU_DESCR Character(30) VARCHAR2(30) NOT NULL This object is a copy of the standard DESCR field, however it contains additional labels not available on the standard.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	GPAU_BANK_DB_TYPE	Character(2)	VARCHAR2(2) NOT NULL	This field distinguishes debit types and is used in the AE program GPAU_EFT_CMX. 10=Group Tax 20=Net Payment 30=Recipient
3	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
4	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
5	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
6	STRM_NUM	Number(4,0)	SMALLINT NOT NULL	Stream Number
7	EMPLID_FROM	Character(11)	VARCHAR2(11) NOT NULL	EMPLID (first for a range)
8	EMPLID_TO	Character(11)	VARCHAR2(11) NOT NULL	Empl ID To
9	GPAU_PMT_TYPE	Character(2)	VARCHAR2(2) NOT NULL	This field allows the user to decide what kind of processing will occurr in the AE program GPAU_EFT_CMX. 10=Net Pay Distribution Only 20=Recipient Deduction Only 30=Net Pay And Recipient 40=Group Tax
10	GPAU_RCPNT_OPTN	Character(2)	VARCHAR2(2) NOT NULL	This is used to identify the recipient option. 10=Select Recipients Only 20=All Recipients 30=Deduction
11	GPAU_RCP_CAL_OPTN	Character(2)	VARCHAR2(2) NOT NULL	This field is used to identify the calculation option to use. 10=Recipient ID 20=All Recipients 30=Deduction
12	PAYMENT_DT	Date(10)	DATE	Payment Date
13	RECIPIENT_ID	Character(8)	VARCHAR2(8) NOT NULL	Payment recipient ID
14	RECIPIENT_TAG	Number(3,0)	SMALLINT NOT NULL	Used to identify recipients for E/D, PI
15	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
16	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
17	ORG_LINK_OPTN	Character(2)	VARCHAR2(2) NOT NULL	Identifies at what org level source banks are assigned. Value set at this time: Company, Dept, Location, Pay Entity, Pay Group CO=Company DE=Department ET=Establishment LO=Location PG=Pay Group
18	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
19	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
20	GP_PMT_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount field on GP PAYMENT table
21	GPAU_EFT_PMT_AMT	Character(10)	VARCHAR2(10) NOT NULL	This field tracks the Payment Amount in a specific character formatted format for the AE program GPAU_EFT_CMX.
22	GPAU_EFT_USER_NO	Character(6)	VARCHAR2(6) NOT NULL	EFT User Number used in the AE program GPAU_EFT_CMX.
23	GPAU_USER_NO	Character(6)	VARCHAR2(6) NOT NULL	EFT User Number used in the AE program GPAU_EFT_CMX.
24	ACCOUNT_NAME	Character(50)	VARCHAR2(50) NOT NULL	Account Name
25	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
26	GPAU_TR_ACCOUNT_CD	Character(35)	VARCHAR2(35) NOT NULL	The Trace Account Code supersedes any account code tracked on the Source Bank Table.
27	GPAU_TR_BRANCH_CD	Character(17)	VARCHAR2(17) NOT NULL	The Trace Branch Code supersedes any Branch Code tracked on the Source Bank Table.
28	GPAU_LODGEMENT_REF	Character(50)	VARCHAR2(50) NOT NULL	This field is used in the AE program GPAU_EFT_CMX.
29	GPAU_PROC_STREAMS	Character(1)	VARCHAR2(1) NOT NULL	This field is used for processing streams.
30	GPAU_ENTRY_DESCR	Character(12)	VARCHAR2(12) NOT NULL	This is the entry description used for CEMTEX processing.
31	GPAU_EFT_TT_NET	Character(10)	VARCHAR2(10) NOT NULL	This field tracks the Net Amount in a specific format for the file generated by the AE program GPAU_EFT_CMX.
32	GPAU_EFT_TT_CR	Character(10)	VARCHAR2(10) NOT NULL	This field tracks the Credit Amount in a specific format for the file generated by the AE program GPAU_EFT_CMX.
33	GPAU_EFT_TT_DB	Character(10)	VARCHAR2(10) NOT NULL	This field tracks the Debit Amount in a specific format for the file generated by the AE program GPAU_EFT_CMX.
34	GPAU_EFT_TT_REC	Character(6)	VARCHAR2(6) NOT NULL	This field tracks the total number of records in a specific format for the file generated by the AE program GPAU_EFT_CMX.
35	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
36	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
37	GPAU_CMX_SEQ_NO	Character(2)	VARCHAR2(2) NOT NULL	This is the Cemtex Seq No.
38	BANK_CD	Character(11)	VARCHAR2(11) NOT NULL	Bank ID
39	ERROR_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Error Type ERR=Stop NON=None WAR=Warning
40	ERROR_CNT	Number(4,0)	SMALLINT NOT NULL	Error Count
41	SRC_BANK_ID	Character(8)	VARCHAR2(8) NOT NULL	Source Bank ID
42	GPAU_EFT_TRANS_CD	Character(2)	VARCHAR2(2) NOT NULL	This field tracks 3 values used in the output file for the AE program GPAU_EFT_CMX. 13=Debit 50=Recipient Credit 53=Payroll Credit
43	EMPLID_PAYEE	Character(11)	VARCHAR2(11) NOT NULL	Payee Empl ID
44	EMPL_RCD_PAYEE	Number(3,0)	SMALLINT NOT NULL	Employment Record for Payee
45	PIN_NUM_LAST	Number(8,0)	INTEGER NOT NULL	Last Used Element Number
46	DEBIT_DT	Date(10)	DATE	Debit Date
47	BRANCH_EC_CD	Character(17)	VARCHAR2(17) NOT NULL	Bank Branch ID
48	ACCOUNT_EC_ID	Character(35)	VARCHAR2(35) NOT NULL	Account Number used in banking.
49	INSTANCE	Number(3,0)	SMALLINT NOT NULL	Instance Number
50	GPAU_RCP_COMM_AMT	Number(9,2)	DECIMAL(8,2) NOT NULL	The Commission Amount is the percentage or flatamount deducted from the payments given to a recipient.
51	GPAU_RCP_COMM_OPTN	Character(2)	VARCHAR2(2) NOT NULL	This is used to identify whether to calculate commission amounts or not. 10=Deduct Commission 20=Report Only 30=None
52	GPAU_RCP_COMM_TYPE	Character(2)	VARCHAR2(2) NOT NULL	The commission type determines if a payment amount is reduced when paying a recipient. 10=Flat Amount 20=Percentage 30=None
53	GPAU_EFT_NET	Number(18,2)	DECIMAL(17,2) NOT NULL	This field tracks the net amount (credit-debit) for the AE program GPAU_EFT_CMX.
54	GPAU_EFT_CR	Signed Number(19,2)	DECIMAL(17,2) NOT NULL	This field tracks the credit amount for the AE program GPAU_EFT_CMX.
55	GPAU_EFT_DB	Signed Number(19,2)	DECIMAL(17,2) NOT NULL	This field tracks the debit amount for the AE program GPAU_EFT_CMX.
56	GPAU_EFT_REC	Number(6,0)	INTEGER NOT NULL	This tracks the number of records processed in the AE program GPAU_EFT_CMX.
57	DESCR15	Character(15)	VARCHAR2(15) NOT NULL	Short Description
58	PRD_BGN_DT	Date(10)	DATE	Period Begin Date
59	PRD_END_DT	Date(10)	DATE	Pay Period End Date
60	GPAU_DESCR	Character(30)	VARCHAR2(30) NOT NULL	This object is a copy of the standard DESCR field, however it contains additional labels not available on the standard.