CPNY_CNT_VW_FRA

(SQL View)
Index Back

Company Contract View

Company Contract View

SELECT A.COMPANY ,A.EFFDT ,A.MEMBERSHIP_NBR_FRA FROM PS_CPNY_CNTRCT_FRA A , PS_COMPANY_TBL B WHERE A.COMPANY=B.COMPANY

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
2 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

3 MEMBERSHIP_NBR_FRA Character(20) VARCHAR2(20) NOT NULL Membership Number - France