WTHD_BU_JUR_VW(SQL View) |
Index Back |
|---|
| SELECT BUSINESS_UNIT , EFFDT , WTHD_ENTITY , WTHD_TYPE , WTHD_JUR_CD , REGISTRATION_TYPE , REGISTRATION_ID , BU_CATEGORY , COLLECT_AGENT_FLG , LAST_CERT_NBR , CODIGO_DGR FROM PS_WTHD_BU_JUR WHERE EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_WTHD_BU_HDR B WHERE B.BUSINESS_UNIT = PS_WTHD_BU_JUR.BUSINESS_UNIT AND B.EFFDT <= %CurrentDateIn AND B.EFF_STATUS = 'A' ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: WTHD_BU_HDR.BUSINESS_UNIT |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: WTHD_BU_HDR.EFFDT |
| 3 | WTHD_ENTITY |
Character(5) | VARCHAR2(5) NOT NULL |
Withholding Entity
Prompt Table: WTHD_ENTITY_DFN |
| 4 | WTHD_TYPE |
Character(5) | VARCHAR2(5) NOT NULL |
Withholding Type
Prompt Table: WTHD_TYPE_TBL |
| 5 | WTHD_JUR_CD |
Character(5) | VARCHAR2(5) NOT NULL |
Withholding Jurisdiction
Prompt Table: WTHD_JUR_TBL |
| 6 | REGISTRATION_TYPE | Character(4) | VARCHAR2(4) NOT NULL | Registration Type |
| 7 | REGISTRATION_ID | Character(20) | VARCHAR2(20) NOT NULL | Registration ID |
| 8 | BU_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit Category
Prompt Table: WTHD_BU_CAT |
| 9 | COLLECT_AGENT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Collection Agent Flag
N=Is NOT Collection Agent Y=Is Collection Agent Y/N Table Edit Default Value: Y |
| 10 | LAST_CERT_NBR | Number(8,0) | INTEGER NOT NULL | Last Certificate Number |
| 11 | CODIGO_DGR | Character(10) | VARCHAR2(10) NOT NULL | Codigo DGR |