GPCH_BV_RESPONS(SQL Table) |
Index Back |
|---|---|
BV response recordBV response record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPCH_EG_DOMAINID | Number(3,0) | SMALLINT NOT NULL | Domain Set ID for the ELM Domain Sets |
| 2 |  GPCH_RC_PAY_YEAR |
Number(4,0) | SMALLINT NOT NULL | Pay Year |
| 3 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 4 | 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 E=EO-APG |
| 5 | GPCH_SI_PROV_CD |
Character(6) | VARCHAR2(6) NOT NULL | Provider Code |
| 6 | GPCH_AL_PROVIDER | Character(10) | VARCHAR2(10) NOT NULL | Provider ID |
| 7 | GPCH_SI_UV_MBR_ID | Character(20) | VARCHAR2(20) NOT NULL | Accident Insurance ID |
| 8 | GPCH_SI_MBR_SUBID | Character(20) | VARCHAR2(20) NOT NULL | Sub ID /Contract |
| 9 | GPCH_RC_DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Signature1 |
| 10 | GPCH_RC_FROM_DT | Date(10) | DATE | From Date |
| 11 | GPCH_AH_NNSS |
Character(20) | VARCHAR2(20) NOT NULL | New Social Insurance ID |
| 12 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 13 | LAST_NAME |
Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 14 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 15 | BIRTHDATE |
Date(10) | DATE | Date of Birth |
| 16 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender
F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec |
| 17 | DESCRINTERNAL | Character(50) | VARCHAR2(50) NOT NULL | Internal Description |
| 18 | HIRE_DT | Date(10) | DATE | First Start Date |
| 19 | TERMINATION_DT | Date(10) | DATE | Termination Date |
| 20 | 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 |
| 21 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 22 | GPCH_RP_CHAR02 |
Character(8) | VARCHAR2(8) NOT NULL | Character 02 |
| 23 | GPCH_RP_AMOUNT1 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Rate Result Value |
| 24 | GPCH_RP_AMOUNT2 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Rate Result Value |
| 25 | GPCH_RP_AMOUNT3 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Rate Result Value |
| 26 | GPCH_RP_CHAR03 |
Character(8) | VARCHAR2(8) NOT NULL | Character 03 |
| 27 | GPCH_RP_AMOUNT4 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Rate Result Value |
| 28 | GPCH_RP_AMOUNT5 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Rate Result Value |
| 29 | GPCH_RP_AMOUNT6 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Rate Result Value |
| 30 | DESCR2 |
Character(30) | VARCHAR2(30) NOT NULL | Descr2 |
| 31 | GPCH_RP_CHAR01 |
Character(6) | VARCHAR2(6) NOT NULL | Character 01 |
| 32 | GPCH_PK_IMPORT | Character(1) | VARCHAR2(1) NOT NULL |
Pension Import
0=Yes 1=No 2=Default |