DSB_BTNR_LOC_VL(SQL View) |
Index Back |
---|---|
German Disability ViewRelated Language View for DSB_BTNR_LOC_VW This view returns the various locations given a specific Company and BTNR (Social Insurance Number). |
SELECT DISTINCT C.COMPANY , S.BTNR , L1.LOCATION , L1.EFFDT , L1.LANGUAGE_CD , L1.DESCR FROM PS_COMP_LOC_TBL C , PS_SI_UNIT_GER S , PS_LOCATION_LANG L1 , PS_LOCATION_TBL L WHERE C.LOCATION = L1.LOCATION AND C.SETID = L1.SETID AND C.SI_UNIT = S.SI_UNIT AND S.EFF_STATUS = 'A' AND L.EFF_STATUS = 'A' AND L.SETID = L1.SETID AND L.LOCATION = L1.LOCATION AND L.EFFDT = L1.EFFDT |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
|
2 | Character(8) | VARCHAR2(8) NOT NULL | Employer Social Insurance Nbr | |
3 | Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table: LOCATION_TBL |
|
4 | Date(10) | DATE |
Effective Date
Default Value: %date |
|
5 | Character(3) | VARCHAR2(3) NOT NULL | Language Code | |
6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |