PAY_ENTITYGPCN_CONTRIB_TYPEPrompt Table: GPCN_CONT_TYPE
GPCN_CONTRIB_AREAEFFDTDefault Value: %date
GPCN_PHFSI_REG(SQL Table) |
Index Back |
|---|---|
Record for PHF/SI Reg detailsThis is a record created to capture GP China PHF/SI Registration details for an organization. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PAY_ENTITY |
Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
| 2 | GPCN_CONTRIB_TYPE |
Character(20) | VARCHAR2(20) NOT NULL |
Contribution Type
Prompt Table: GPCN_CONT_TYPE |
| 3 | GPCN_CONTRIB_AREA |
Character(30) | VARCHAR2(30) NOT NULL | Contribution Area |
| 4 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 5 | GPCN_REG_NO | Character(20) | VARCHAR2(20) NOT NULL | This field Captures Registration Number for China. |
| 6 | GPCN_REG_AUTH | Character(50) | VARCHAR2(50) NOT NULL | This field captures Registration Authority in China. |
| 7 | GPCN_REGRENW_DT | Date(10) | DATE | This field Captures Registration renewal Date in China |