GPTH_TX_BRN_VW1(SQL View) |
Index Back |
|---|---|
Tax Branch InfoTax Branch Info |
| SELECT A.COMPANY , A.GPTH_TAX_ID , A.GPTH_TAX_BRANCH , A.GPTH_TAX_ID_L , G.PROCESS_INSTANCE , G.EMPLID FROM PS_GPTH_TAX_ID_BRN A ,PS_GPTH_RPT_G_VW G WHERE A.COMPANY=G.COMPANY AND A.EFF_STATUS='A' AND A.EFFDT=( SELECT MAX(A_ED.EFFDT) FROM PS_GPTH_TAX_ID_BRN A_ED WHERE A_ED.COMPANY=A.COMPANY AND A_ED.EFFDT <= ( SELECT MAX(G1.PRD_END_DT) FROM PS_GPTH_RPT_G_VW G1 WHERE G.PROCESS_INSTANCE=G1.PROCESS_INSTANCE AND G.Company=G1.COMPANY )) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 2 | GPTH_TAX_ID | Character(10) | VARCHAR2(10) NOT NULL | Tax identification number |
| 3 | GPTH_TAX_BRANCH | Character(4) | VARCHAR2(4) NOT NULL | Tax branch number |
| 4 | GPTH_TAX_ID_L | Character(13) | VARCHAR2(13) NOT NULL | Tax identification number 13 |
| 5 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 6 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |