EMPL_DT_SRCH(SQL View) |
Index Back |
---|---|
Srch View Payroll EffdtThis search view is used to locate specific payroll data. |
select emplid, company,effdt from PS_FED_TAX_DATA |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
2 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
3 | EFFDT | Date(10) | DATE | Effective Date |