GPCN_SI_RPT_AET(SQL Table) |
Index Back |
|---|---|
SI-PHF Report State Record.State record for SI-PHF Report in XML format. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 5 | 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 |
| 6 | GPCN_RECREATE | Character(1) | VARCHAR2(1) NOT NULL | Recreate |
| 7 | GPCN_YEARCD | Character(4) | VARCHAR2(4) NOT NULL | Year Code (along with translate values) |
| 8 | BGN_DT | Date(10) | DATE | Begin Date |
| 9 | END_DT | Date(10) | DATE | end date |
| 10 | GPCN_CONTRIB_AREA | Character(30) | VARCHAR2(30) NOT NULL | Contribution Area |
| 11 | GPCN_CONTRIB_TYPE | Character(20) | VARCHAR2(20) NOT NULL | Contribution Type |
| 12 | GPCN_CONT_TYPE | Character(20) | VARCHAR2(20) NOT NULL | Contribution Type |
| 13 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 14 | GPCN_PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL | GP China Pay Entity |
| 15 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |
| 16 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
| 17 | GPCN_REPORT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
PHF/SI Report Type for RCTL page.
A=Monthly Contribution Report B=Eligibility Report C=Annual Base Report |
| 18 | GPCN_ORG_CODE | Character(50) | VARCHAR2(50) NOT NULL | Organization Code |
| 19 | GPCN_ORG_CATAGORY | Character(2) | VARCHAR2(2) NOT NULL |
Organization Category for China
01=Juridical Enterprise 02=Juridical Institution 03=Juridical Association 04=Juridical Government Org 05=Non-Juridical Enterprise 06=Non-Juridical Institution 07=Non-Juridical Association 08=Non-Juridical Government Org |
| 20 | GPCN_ORG_XLAT | Character(30) | VARCHAR2(30) NOT NULL | Organisation code Xlat long name |
| 21 | GPCN_FILING_DT | Date(10) | DATE | This field will give the date on filling the reports. |
| 22 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 23 | GPCN_CHANGE_REASON | Character(30) | VARCHAR2(30) NOT NULL | Reason of Account Status change |
| 24 | GPCN_HUKOU_TYPE | Character(20) | VARCHAR2(20) NOT NULL | Employee Hukou Type |
| 25 | GPCN_REQ_LOSS | Character(1) | VARCHAR2(1) NOT NULL |
Requisition/Loss of Eligibility Indicator
1=New Employee 2=Terminated Employee 3=Death of Employee |
| 26 | GPCN_PHFSI_SRT_KY1 | Character(1) | VARCHAR2(1) NOT NULL |
PHF/SI Sort Key 1
0=Not Applicable 2=Employee Number 3=Employee Name 4=PHF/SI Account Number |
| 27 | GPCN_PHFSI_SRT_KY2 | Character(1) | VARCHAR2(1) NOT NULL |
PHF/SI Sort Key 1
0=Not Applicable 2=Employee Number 3=Employee Name 4=PHF/SI Account Number |
| 28 | GPCN_PHFSI_SRT_KY3 | Character(1) | VARCHAR2(1) NOT NULL |
PHF/SI Sort Key 1
0=Not Applicable 2=Employee Number 3=Employee Name 4=PHF/SI Account Number |
| 29 | DYNAMIC_SQL | Character(100) | VARCHAR2(100) NOT NULL | Dynamic SQL |
| 30 | DYNAMIC_SQL_IMP | Character(200) | VARCHAR2(200) NOT NULL | Dynamic SQL |
| 31 | SQL_TEXT | Character(80) | VARCHAR2(80) NOT NULL | SQL Text |
| 32 | TEMP_FLD | Character(1) | VARCHAR2(1) NOT NULL | Temporary Field for App Engine |