GPUS_COMPEIN_VW

(SQL View)
Index Back

EINs reported by Reporting Co

EINs reported by Reporting Company

SELECT EFFDT , %numtochar(FEDERAL_EIN) , COMPANY , DESCR FROM PS_COMPANY_TBL WHERE FEDERAL_EIN <> 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EFFDT Date(10) DATE Effective Date

Default Value: %date

2 GPUS_TAX_EIN Character(9) VARCHAR2(9) NOT NULL Federal Employer Identification Number
3 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description