GPCH_BV_RESPONS

(SQL Table)
Index Back

BV response record

BV response record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GPCH_RC_PAY_YEAR Number(4,0) SMALLINT NOT NULL Pay Year
2 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
3 GPCH_SI_PROV_TYPE Character(1) VARCHAR2(1) NOT NULL Provider Type
0=Identify
1=Others
2=UVG-LAA
3=KTG-AMC
4=UVGZ-LAAC
5=FAK-CAF
6=BVG-LPP
7=AHV-AVS
8=LAW-CDS
9=BFS-OFS
A=QST-IS
B=Write File
C=Base AL08
D=GRFI-FRFI
E=EO-APG
I=BNK_BNQ
4 GPCH_SI_PROV_CD Character(6) VARCHAR2(6) NOT NULL Provider Code
5 GPCH_AH_NNSS Character(20) VARCHAR2(20) NOT NULL New Social Insurance ID
6 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
7 BIRTHDATE Date(10) DATE Date of Birth
8 GPCH_RP_CHAR02 Character(8) VARCHAR2(8) NOT NULL Character 02
9 GPCH_RP_CHAR03 Character(8) VARCHAR2(8) NOT NULL Character 03
10 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2
11 GPCH_RP_CHAR01 Character(6) VARCHAR2(6) NOT NULL Character 01
12 GPCH_EG_DOMAINID Number(3,0) SMALLINT NOT NULL Domain Set ID for the ELM Domain Sets
13 GPCH_AL_PROVIDER Character(10) VARCHAR2(10) NOT NULL Provider ID
14 GPCH_SI_UV_MBR_ID Character(20) VARCHAR2(20) NOT NULL Accident Insurance ID
15 GPCH_SI_MBR_SUBID Character(20) VARCHAR2(20) NOT NULL Sub ID /Contract
16 GPCH_RC_DESCR1 Character(30) VARCHAR2(30) NOT NULL Signature1
17 GPCH_RC_FROM_DT Date(10) DATE From Date
18 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
19 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
20 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
21 DESCRINTERNAL Character(50) VARCHAR2(50) NOT NULL Internal Description
22 HIRE_DT Date(10) DATE First Start Date
23 TERMINATION_DT Date(10) DATE Termination Date
24 GPCH_EG_PRSN_XML Long Character CLOB used to store the Personal Total XML data generated by the SQR in Year End Process for each employee for each functional type
25 BEGIN_DT Date(10) DATE Begin Date
26 GPCH_RP_AMOUNT1 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
27 GPCH_RP_AMOUNT2 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
28 GPCH_RP_AMOUNT3 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
29 GPCH_RP_AMOUNT4 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
30 GPCH_RP_AMOUNT5 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
31 GPCH_RP_AMOUNT6 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
32 GPCH_PK_IMPORT Character(1) VARCHAR2(1) NOT NULL Pension Import
0=Yes
1=No
2=Default