COMPANYPrompt Table: COMPANY_TBL
SETIDPrompt Table: SETID_TBL
LOCATIONPrompt Table: LOCATION_TBL
EFFDTPrompt Table: WC_COUNCIL_TBL
Prompt Table: SPK_COMM_GER
Prompt Table: SI_UNIT_GER
COMP_LOC_VW(SQL View) |
Index Back |
|---|---|
Company Location tableCompany Location table |
| SELECT COMPANY ,SETID ,LOCATION ,EFFDT ,WC_COUNCIL_ID ,SPK_COMM_ID_GER ,SI_UNIT FROM PS_COMP_LOC_TBL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 2 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SETID_TBL |
| 3 | LOCATION |
Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table: LOCATION_TBL |
| 4 | EFFDT |
Date(10) | DATE | Effective Date |
| 5 | WC_COUNCIL_ID | Character(9) | VARCHAR2(9) NOT NULL |
Works Council ID
Prompt Table: WC_COUNCIL_TBL |
| 6 | SPK_COMM_ID_GER | Character(9) | VARCHAR2(9) NOT NULL |
Spokesmen Committee ID
Prompt Table: SPK_COMM_GER |
| 7 | SI_UNIT | Character(6) | VARCHAR2(6) NOT NULL |
Social Insurance Unit
Prompt Table: SI_UNIT_GER |