PY_PFF_PGID_CHD

(SQL Table)
Index Back

Program Id child record

Program Id child record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PY_PFF_PROGID Character(4) VARCHAR2(4) NOT NULL Program ID
2 EFFDT Date(10) DATE Effective Date

Default Value: %date

3 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
4 TAX_CLASS Character(3) VARCHAR2(3) NOT NULL Tax Balance Class

Prompt Table: PY_TAX_CLASS

5 PY_PFF_TAX_CAT Character(1) VARCHAR2(1) NOT NULL Taxability Type
E=Employee
R=Employer

Default Value: E

6 PY_PFF_STAT_VOL Character(1) VARCHAR2(1) NOT NULL Tax Class Attribute
S=State
V=Voluntary

Default Value: S

7 ACTIVITY Character(3) VARCHAR2(3) NOT NULL Payroll Activity
8 PYGL_TAX_CLASS Character(3) VARCHAR2(3) NOT NULL Tax Class Description

Prompt Table: PY_PFF_GL_VW
Set Control Field: PYGL_TAX_CLASS