COMPANYPrompt Table: COMPANY_TBL
BTNRLOCATIONPrompt Table: LOCATION_TBL
EFFDTDefault Value: %date
LANGUAGE_CDDSB_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 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 2 | BTNR |
Character(8) | VARCHAR2(8) NOT NULL | Employer Social Insurance Nbr |
| 3 | LOCATION |
Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table: LOCATION_TBL |
| 4 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 5 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |