GPJP_SC_BNS_RPT

(SQL Table)
 Index Back

SI Bonus Payment Report Data

Contains SI Bonus Payment Report data for each employee. There will be one row of data for each employee.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 JOBINSTANCE Number(10,0) DECIMAL(10) NOT NULL Job Instance
2 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
5 NAME Character(50) VARCHAR2(50) NOT NULL Name
6 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name
7 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
8 GPJP_TAX_ESTAB Character(15) VARCHAR2(15) NOT NULL Salary Payer Reference Number
9 GPJP_HLTH_CARD_NUM Number(8,0) INTEGER NOT NULL Health Insurance Card Number.
10 PYMT_DT Date(10) DATE Payment Date
11 GPJP_CHG_FLG Character(2) VARCHAR2(2) NOT NULL Status Change Reason Field.
01=New enrollment
02=Re-enrollment
03=Loss by Death
04=Loss by Age (PI)
05=Loss by Other Reason
06=Occasional Revision
07=Regular Decision
08=Other
09=Excluded
10=New Enrollment after Loss
11=Revision after Maternity Leave
11=Rev. after Mat./Preg. Leave
12=Loss by Age (HI)
13=Loss by Disability
12 GPJP_MAT_LEAVE_FLG Character(1) VARCHAR2(1) NOT NULL Maternity Leave.
13 SEQ_NUM8 Number(8,0) INTEGER NOT NULL Sequence Number
14 BIRTHDATE Date(10) DATE Date of Birth
15 GPJP_CHRDT_ERA1 Character(1) VARCHAR2(1) NOT NULL Imperial Era
16 GPJP_CHRDT_YYMMDD1 Character(6) VARCHAR2(6) NOT NULL Character Date as YYMMDD
17 GPJP_CHRDT_ERA2 Character(1) VARCHAR2(1) NOT NULL Imperial Era
18 GPJP_CHRDT_YYMMDD2 Character(6) VARCHAR2(6) NOT NULL Character Date as YYMMDD
19 GPJP_MTH_CASH_RMN Signed Number(20,6) DECIMAL(18,6) NOT NULL Estimated Cash Monthly Remun
20 GPJP_MTH_MAT_RMN Signed Number(20,6) DECIMAL(18,6) NOT NULL Estimated Non-Cash Mthly Remun
21 GPJP_SUM_MTH_RMN Signed Number(20,6) DECIMAL(18,6) NOT NULL Sum Of Monthly Remuneration In N.