CANADA_BNPY_CAN_BN_VW(SQL View) |
Index Back |
|---|---|
Canada Business Number view |
| SELECT DISTINCT A.CANADA_BN FROM PS_WAGELS_PLAN_TBL A WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_WAGELS_PLAN_TBL A1 WHERE A1.COMPANY = A.COMPANY AND A1.WAGE_LOSS_PLAN = A.WAGE_LOSS_PLAN AND A1.CANADA_BN <> ' ' AND A1.EFFDT <= %CurrentDateIn ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CANADA_BN |
Character(15) | VARCHAR2(15) NOT NULL | Payroll Account Number |