COMPANYEFFDTDefault Value: %date
E=Exempt
M=Medicare Only
N=Subject
GPUS_COMPANY_VW(SQL View) |
Index Back |
|---|---|
Companies for tax calculationView used in order to retrieve data from companies for tax calculation |
| SELECT COMPANY , EFFDT , FICA_STATUS_ER , %numtochar(FEDERAL_EIN) FROM PS_COMPANY_TBL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | GPUS_FICA_ER | Character(1) | VARCHAR2(1) NOT NULL |
FICA Status Employee
E=Exempt M=Medicare Only N=Subject |
| 4 | GPUS_TAX_EIN | Character(9) | VARCHAR2(9) NOT NULL | Federal Employer Identification Number |