GPMX_PTU_PARM

(SQL Table)
Index Back

PTU Yearly Parameters

PTU by Company Yearly Parameters

# 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 GPMX_BALANCE_YEAR Number(4,0) SMALLINT NOT NULL Balance Year GP Mexico
4 GPMX_PROP_DAYS Character(1) VARCHAR2(1) NOT NULL Apply Proportional Worked Days to the PTU process

Y/N Table Edit

Default Value: N

5 GPMX_TOT_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Total Amount
6 GPMX_TEMP_PYE Character(1) VARCHAR2(1) NOT NULL Allow Not Full Time Employees

Y/N Table Edit

Default Value: N

7 GPMX_TEMP_DAYS Number(3,0) SMALLINT NOT NULL Temporal Payees Number of Days
8 GPMX_CEIL_SALARY Number(15,6) DECIMAL(14,6) NOT NULL Ceiling Salary
9 GPMX_DAY_FACTOR Number(14,7) DECIMAL(13,7) NOT NULL Daily Factor
10 GPMX_SALARY_FACTOR Number(15,7) DECIMAL(14,7) NOT NULL Amount Factor