GPTH_EFT_AET

(SQL Table)
Index Back

The State Record

The State Record of the Component GPTH_EFT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
5 SRC_BANK_ID Character(8) VARCHAR2(8) NOT NULL Source Bank ID
6 GPTH_ISSUE_DATE Date(10) DATE Issue Date
7 GPTH_EFT_ALL_EE Character(1) VARCHAR2(1) NOT NULL Indicate whether to include employees who's status is "Transfered". The default value is 'Y'

Y/N Table Edit

Default Value: Y

8 ERROR_TYPE Character(3) VARCHAR2(3) NOT NULL Error Type
ERR=Stop
NON=None
WAR=Warning
9 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?
10 GPTH_BATCH_CONTROL Character(4) VARCHAR2(4) NOT NULL Batch-Control
11 GPTH_COMPANY_CODE Character(7) VARCHAR2(7) NOT NULL Company Code
12 GPTH_DDP_ORIG_ID Character(4) VARCHAR2(4) NOT NULL DDP Originator ID
13 GPTH_FINANCE_ID Character(3) VARCHAR2(3) NOT NULL Finance ID
14 GPTH_TRANS_TYPE Character(4) VARCHAR2(4) NOT NULL Trans-Type