PROCESSINSTANCECOMPANYPrompt Table: COMPANY_TBL
PAYGROUPPrompt Table: PAYGROUP_TBL
PAY_END_DTPrompt Table: PAY_CALENDAR
TAX_CLASSSTATEPY_PFF_TAX_CATE=Employee
R=Employer
PY_PFF_TAX_STL=Locality
S=State
U=Federal
PYGL_TAX_CLASSPY_PFFTXGL_STG(SQL Table) |
Index Back |
|---|---|
Staging tableStaging table for commitment accounting |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESSINSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 3 | PAYGROUP |
Character(3) | VARCHAR2(3) NOT NULL |
Pay Group
Prompt Table: PAYGROUP_TBL |
| 4 | PAY_END_DT |
Date(10) | DATE NOT NULL |
Pay Period End Date
Prompt Table: PAY_CALENDAR |
| 5 | TAX_CLASS |
Character(3) | VARCHAR2(3) NOT NULL | Tax Balance Class |
| 6 | STATE |
Character(6) | VARCHAR2(6) NOT NULL | State |
| 7 | PY_PFF_TAX_CAT |
Character(1) | VARCHAR2(1) NOT NULL |
Taxability Type
E=Employee R=Employer |
| 8 | PY_PFF_TAX_ST |
Character(1) | VARCHAR2(1) NOT NULL |
PY_PFF_TAX_ST
L=Locality S=State U=Federal |
| 9 | PYGL_TAX_CLASS |
Character(3) | VARCHAR2(3) NOT NULL | Tax Class Description |
| 10 | PNA_GL_LIB_ACC | Character(35) | VARCHAR2(35) NOT NULL | GL Account MLI Employee. |