GPTH_PF_CTR(SQL Table) |
Index Back |
---|---|
Company PF ContributionCompany PF Contribution |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
2 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
3 | GPTH_PF_MNGR | Character(50) | VARCHAR2(50) NOT NULL | Provident Fund Manager Name |
4 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
5 | GPTH_PF_LEN_TO | Number(2,0) | SMALLINT NOT NULL | Length of service to |
6 | GPTH_PF_LEN_FROM | Number(2,0) | SMALLINT NOT NULL | Length of service from |
7 | GPTH_PF_ER_PER | Number(5,2) | DECIMAL(4,2) NOT NULL | Provident Fund Employer Rate |
8 | GPTH_PF_EE_PER | Number(5,2) | DECIMAL(4,2) NOT NULL | Provident Fund Employee Rate |
9 | GPTH_CHAR1_FLG | Character(1) | VARCHAR2(1) NOT NULL |
This field is only used as flag.
not shown on page.
A=Not Changed B=Changed Default Value: A |