GPCN_NRP_PSI_VW(SQL View) |
Index Back |
|---|---|
Segment Guide WASegment Guide WA could be used for extraction and reporting. |
| SELECT EMPLID ,EMPL_RCD ,GPCN_MONTHCD ,GPCN_YEARCD ,GP_PAYGROUP ,GPCN_CONTRIB_AREA ,GPCN_CONTRIB_TYPE ,PIN_NUM + 50000000 ,GPCN_ACOUNT_NUM ,GPCN_ACNT_STATUS ,GPCN_CHANGE_REASON ,GPCN_HUKOU_TYPE ,GPCN_MONTHLY_BASE ,GPCN_PREV_AVG_SAL ,GPCN_CONT_BASE_ER ,GPCN_CONT_PCT_ER ,GPCN_CONT_BASE_EE ,GPCN_CONT_PCT_EE ,GPCN_CONT_AMT_EE ,GPCN_CONT_AMT_ER ,GPCN_CONT_TOT_AMT ,GPCN_CONT_ADJ_EE ,GPCN_CONT_ADJ_ER ,GPCN_CONT_METHOD ,GPCN_START_DT ,GPCN_TER_DATE ,GPCN_PHFSI_TERM_YN FROM PS_GPCN_PHFSI_RPTG |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON_NAME |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 3 | GPCN_MONTHCD |
Character(2) | VARCHAR2(2) NOT NULL |
Month Code (along with translate values)
01=January 02=February 03=March 04=April 05=May 06=June 07=July 08=August 09=September 10=October 11=November 12=December |
| 4 | GPCN_YEARCD |
Character(4) | VARCHAR2(4) NOT NULL | Year Code (along with translate values) |
| 5 | GP_PAYGROUP |
Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 6 | GPCN_CONTRIB_AREA |
Character(30) | VARCHAR2(30) NOT NULL | Contribution Area |
| 7 | GPCN_CONTRIB_TYPE |
Character(20) | VARCHAR2(20) NOT NULL | Contribution Type |
| 8 | PIN_NUM | Number(8,0) | INTEGER NOT NULL | PIN Number |
| 9 | GPCN_ACOUNT_NUM | Character(20) | VARCHAR2(20) NOT NULL | Employee Account Number |
| 10 | GPCN_ACNT_STATUS | Character(25) | VARCHAR2(25) NOT NULL |
Account Status
01=New Enrollment 02=Transfer-in from same district 03=Transfer from same admin area 04=Transfer from diff admin area 05=Rejoin 06=Retire 07=Transfer to same admin area 08=Transfer to diff admin area 09=End of Employment Contract 10=Death of Employee 11=Others |
| 11 | GPCN_CHANGE_REASON | Character(30) | VARCHAR2(30) NOT NULL | Reason of Account Status change |
| 12 | GPCN_HUKOU_TYPE | Character(20) | VARCHAR2(20) NOT NULL | Employee Hukou Type |
| 13 | GPCN_MONTHLY_BASE | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Employee Monthly Base Salary |
| 14 | GPCN_PREV_AVG_SAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Employee Average Monthly Salary for Previous Year |
| 15 | GPCN_CONT_BASE_ER | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Employer Contribution base |
| 16 | GPCN_CONT_PCT_ER | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Employer Contribution Percentage |
| 17 | GPCN_CONT_BASE_EE | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Employee Contribution Base |
| 18 | GPCN_CONT_PCT_EE | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Employee Contribution Percentage |
| 19 | GPCN_CONT_AMT_EE | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Employee Contribution Amount |
| 20 | GPCN_CONT_AMT_ER | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Employer Contribution Amount |
| 21 | GPCN_CONT_TOT_AMT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Total Contribution Amount |
| 22 | GPCN_CONT_ADJ_EE | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Employee Contribution Adjustment |
| 23 | GPCN_CONT_ADJ_ER | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Employer Contribution Adjustment |
| 24 | GPCN_CONT_METHOD | Character(2) | VARCHAR2(2) NOT NULL | PHF/SI Contribution Method |
| 25 | GPCN_START_DT | Date(10) | DATE | Start Date |
| 26 | GPCN_TER_DATE | Date(10) | DATE | Termination date for PHF/SI Contribution |
| 27 | GPCN_PHFSI_TERM_YN | Character(1) | VARCHAR2(1) NOT NULL | Indicates whether or not PHFSI deductions should be paid whilst an employee is on termination |