EMPL_DT_SRCH

(SQL View)
Index Back

Srch View Payroll Effdt

This 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