COMPANYEFFDTDefault Value: %date
LANGUAGE_CDDSB_GER_COMP_VL(SQL View) |
Index Back |
|---|---|
German Disability Lang ViewRelated language view for DSB_GER_COMP_VW This view shows companies who are also defined in the COMP_LOC_TBL, SI_UNIT_GER, and have locations in Germany. |
| SELECT DISTINCT D.COMPANY , D.EFFDT , D.LANGUAGE_CD , D.DESCR FROM PS_COMP_LOC_TBL A , PS_SI_UNIT_GER B , PS_LOCATION_TBL C , PS_COMPNY_TBL_LANG D WHERE A.SETID = C.SETID AND A.LOCATION = C.LOCATION AND C.COUNTRY = 'DEU' AND A.COMPANY = D.COMPANY AND A.SI_UNIT = B.SI_UNIT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |