EFFDTDefault Value: %date
PROVINCEDefault Value: 99999
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 |