STCAN_PROV_NW

(SQL View)
 Index Back

Stats CAN Province


SELECT EFFDT , PROVINCE , HP_STATS_PROV_CD FROM PS_CAN_TAX_PROV A WHERE EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_CAN_TAX_PROV B WHERE B.EFFDT <= %CurrentDateIn) AND PROVINCE IN ('AB', 'BC', 'MB', 'NB', 'NL', 'NS', 'NT', 'ON', 'PE', 'QC', 'SK', 'YT', 'ZZ', 'NU')

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

Default Value: %date

2 PROVINCE Character(6) VARCHAR2(6) NOT NULL Province
3 HP_STATS_PROV_CD Character(5) VARCHAR2(5) NOT NULL Stats Can Province Code

Default Value: 99999