GPCN_TAX_A_S_D

(SQL Table)
Index Back

Avg Annual & Min MonthlySalary

Avg Annual & Min Monthly Salary

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GPCN_TAX_AREA Character(30) VARCHAR2(30) NOT NULL Tax Area

Prompt Table: GPCN_TAX_AR_VW

2 GPCN_YEAR Number(4,0) SMALLINT NOT NULL Year Number-4
3 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

4 GPCN_PREV_AVG_SAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Employee Average Monthly Salary for Previous Year
5 GPCN_MIN_MON_SAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Minimum Monthly Salary, legal data by Government
6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: CNY

Prompt Table: CURRENCY_CD_TBL