T4A_TAXFORM_VW2(SQL View) |
Index Back |
---|---|
Prior 2010 T4A Boxes |
SELECT A.BOX , A.DESCR FROM PS_TAXFORM_BOX A WHERE A.TAXFORM_ID = 'A' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_TAXFORM_BOX B WHERE B.TAXFORM_ID = A.TAXFORM_ID AND B.EFFDT < %DateIn('2010-01-01')) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BOX | Character(4) | VARCHAR2(4) NOT NULL | Box |
2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |