GPNL_SOC_NUM_VW (SQL View)	Index Back
Company Social Security Nbrs Company Social Security Numbers.

GPNL_SOC_NUM_VW

(SQL View)

Company Social Security Nbrs

Company Social Security Numbers.

SELECT DISTINCT A.COMPANY , B.GPNL_SOC_NUM FROM PS_ESTAB_TBL A , PS_GPNL_ESTAB_TBL B WHERE A.ESTABID = B.ESTABID AND A.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Prompt Table: COMPANY_TBL

2 GPNL_SOC_NUM Character(20) VARCHAR2(20) NOT NULL Social Security Number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
2	GPNL_SOC_NUM	Character(20)	VARCHAR2(20) NOT NULL	Social Security Number