CAN_GOV_CNTYVW1

(SQL View)
Index Back

ESIS view of CAN_GOV_COUNTY

New view of CAN_GOV_COUNTY

SELECT A.CAN_ESIS_COUNTY , A.PROVINCE , A.COUNTY FROM PS_CAN_GOV_COUNTY A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CAN_ESIS_COUNTY Character(4) VARCHAR2(4) NOT NULL SAC-R75-19990831
2 PROVINCE Character(6) VARCHAR2(6) NOT NULL Province

Prompt Table: PROVINCE_VW

3 COUNTY Character(30) VARCHAR2(30) NOT NULL County