GPCH_BV_LOAD_VW(SQL View) |
Index Back |
|---|---|
BV load viewBV load view. |
| SELECT N.NAME , P.PIN_NM , P.DESCR , OV.BGN_DT , OV.GP_AMT , R.GPCH_EG_DOMAINID ,R.GPCH_RC_PAY_YEAR ,R.COMPANY ,R.GPCH_SI_PROV_TYPE ,R.GPCH_SI_PROV_CD ,R.GPCH_AL_PROVIDER ,R.GPCH_SI_UV_MBR_ID ,R.GPCH_SI_MBR_SUBID ,R.GPCH_RC_DESCR1 ,R.GPCH_RC_FROM_DT ,R.GPCH_AH_NNSS ,R.EMPLID ,R.LAST_NAME ,R.FIRST_NAME ,R.BIRTHDATE ,R.SEX ,R.DESCRINTERNAL ,R.HIRE_DT ,R.TERMINATION_DT ,R.GPCH_EG_PRSN_XML ,R.BEGIN_DT ,R.GPCH_RP_CHAR02 ,R.GPCH_RP_AMOUNT1 ,R.GPCH_RP_AMOUNT2 ,R.GPCH_RP_AMOUNT3 ,R.GPCH_RP_CHAR03 ,R.GPCH_RP_AMOUNT4 ,R.GPCH_RP_AMOUNT5 ,R.GPCH_RP_AMOUNT6 ,R.DESCR2 ,R.GPCH_RP_CHAR01 ,R.GPCH_PK_IMPORT FROM PS_GP_PYE_OVRD OV , PS_NAMES N , PS_GP_PIN P , PS_GPCH_BV_RESPONS R , PS_GP_BRACKET_DTL BR WHERE OV.PIN_NUM = P.PIN_NUM AND OV.EMPLID = N.EMPLID AND OV.EMPLID = R.EMPLID AND R.GPCH_RP_CHAR01 = 'Salary' AND R.GPCH_PK_IMPORT <> '2' AND BR.PIN_NUM IN ( SELECT PIN_NUM FROM PS_GP_PIN WHERE PIN_NM = 'CH_PK_BR005') AND BR.PIN_VAL2_NUM = P.PIN_NUM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 2 | PIN_NM | Character(18) | VARCHAR2(18) NOT NULL | Element Name field |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | BGN_DT | Date(10) | DATE | Begin Date |
| 5 | GP_AMT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Amount |
| 6 |  GPCH_EG_DOMAINID |
Number(3,0) | SMALLINT NOT NULL | Domain Set ID for the ELM Domain Sets |
| 7 | GPCH_RC_PAY_YEAR |
Number(4,0) | SMALLINT NOT NULL | Pay Year |
| 8 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 9 | 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 |
| 10 | GPCH_SI_PROV_CD |
Character(6) | VARCHAR2(6) NOT NULL | Provider Code |
| 11 | GPCH_AL_PROVIDER | Character(10) | VARCHAR2(10) NOT NULL | Provider ID |
| 12 | GPCH_SI_UV_MBR_ID | Character(20) | VARCHAR2(20) NOT NULL | Accident Insurance ID |
| 13 | GPCH_SI_MBR_SUBID | Character(20) | VARCHAR2(20) NOT NULL | Sub ID /Contract |
| 14 | GPCH_RC_DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Signature1 |
| 15 | GPCH_RC_FROM_DT | Date(10) | DATE | From Date |
| 16 | GPCH_AH_NNSS |
Character(20) | VARCHAR2(20) NOT NULL | New Social Insurance ID |
| 17 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 18 | LAST_NAME |
Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 19 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 20 | BIRTHDATE |
Date(10) | DATE | Date of Birth |
| 21 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender
F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec |
| 22 | DESCRINTERNAL | Character(50) | VARCHAR2(50) NOT NULL | Internal Description |
| 23 | HIRE_DT | Date(10) | DATE | First Start Date |
| 24 | TERMINATION_DT | Date(10) | DATE | Termination Date |
| 25 | 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 |
| 26 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 27 | GPCH_RP_CHAR02 | Character(8) | VARCHAR2(8) NOT NULL | Character 02 |
| 28 | GPCH_RP_AMOUNT1 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Rate Result Value |
| 29 | GPCH_RP_AMOUNT2 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Rate Result Value |
| 30 | GPCH_RP_AMOUNT3 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Rate Result Value |
| 31 | GPCH_RP_CHAR03 | Character(8) | VARCHAR2(8) NOT NULL | Character 03 |
| 32 | GPCH_RP_AMOUNT4 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Rate Result Value |
| 33 | GPCH_RP_AMOUNT5 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Rate Result Value |
| 34 | GPCH_RP_AMOUNT6 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Rate Result Value |
| 35 | DESCR2 |
Character(30) | VARCHAR2(30) NOT NULL | Descr2 |
| 36 | GPCH_RP_CHAR01 |
Character(6) | VARCHAR2(6) NOT NULL | Character 01 |
| 37 | GPCH_PK_IMPORT | Character(1) | VARCHAR2(1) NOT NULL |
Pension Import
0=Yes 1=No 2=Default |