GPUS_PPD_AET

(SQL Table)
Index Back

state record for PPD process

State Record for the EFT PPD process for USA

# 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 EFT_NAME Character(10) VARCHAR2(10) NOT NULL EFT Format Name

Prompt Table: GPUS_EFT_FMT_VW

6 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
7 SRC_BANK_ID Character(8) VARCHAR2(8) NOT NULL Source Bank ID
8 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: GPUS_COM_VW

9 FEDERAL_EIN Number(9,0) DECIMAL(9) NOT NULL Federal EIN
10 ERROR_TYPE Character(3) VARCHAR2(3) NOT NULL Error Type
ERR=Stop
NON=None
WAR=Warning