GPJP_SC_BNS_AET

(SQL Table)
Index Back

GPJP_SC_BNS State record

Stores temporary information required to run the AE program

# 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 GPJP_PREFECTURE_CD Character(2) VARCHAR2(2) NOT NULL Prefecture Code
5 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
6 GPJP_TAX_ESTAB Character(15) VARCHAR2(15) NOT NULL Salary Payer Reference Number
7 GPJP_ACTL_PMNT_DT Date(10) DATE The date when the bonus is actually payed
8 GPJP_PLAN_PMNT_DT Date(10) DATE The date when the bonus was planned to be payed
9 GPJP_SC_ESTAB_REF1 Character(10) VARCHAR2(10) NOT NULL Establishment Reference Number.
10 GPJP_SC_ESTAB_REF2 Character(10) VARCHAR2(10) NOT NULL Establishment Reference Number 2.
11 GPJP_PENS_FUND_FLG Character(1) VARCHAR2(1) NOT NULL Employee's Pension Fund
12 GPJP_PAYEE_ID_TYPE Character(1) VARCHAR2(1) NOT NULL Payee ID Type
1=Health Insurance Card Number
2=Pension Insurance Code
13 GPJP_SC_ESTAB2 Character(5) VARCHAR2(5) NOT NULL Establishment Number
14 GPJP_CREATE_DT Date(10) DATE File Creation Date
15 SEQ_NUM8 Number(8,0) INTEGER NOT NULL Sequence Number
16 ERROR_TYPE Character(3) VARCHAR2(3) NOT NULL Error Type
ERR=Stop
NON=None
WAR=Warning
17 FILE_HANDLE Character(2) VARCHAR2(2) NOT NULL File Handle
18 GPJP_MEDIA Character(1) VARCHAR2(1) NOT NULL Media
E=Electronic Application
F=Floppy Disk
M=MO Disk
19 JOBINSTANCE Number(10,0) DECIMAL(10) NOT NULL Job Instance
20 GPJP_FD_SEQ Number(3,0) SMALLINT NOT NULL FD Sequential Number
21 GPJP_SEQ_NUM1 Number(8,0) INTEGER NOT NULL Sequence Number 1
22 STRING_TEXT Character(100) VARCHAR2(100) NOT NULL String Text
23 WHERE_VALUE Character(50) VARCHAR2(50) NOT NULL Value for rule selection criteria.
24 WHERE_VALUE1 Character(30) VARCHAR2(30) NOT NULL Value for rule selection criteria.