PY_PFF_PGID_CHD(SQL Table) |
Index Back |
---|---|
Program Id child recordProgram 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
|