VEH_EQUIPVW_LNG(SQL View) |
Index Back |
---|---|
Rellang Vehi/Heavy Equip ViewVEH_EQUIP_VW is a view of COMP_PROP_TBL (Company Property Table) that is used as a prompt table for vehicle/equipment data in the Health and Safety module. The view selects only those records where the property type is 'heavy equipment' or 'vehicle'. |
SELECT A.PROPERTY_ID ,B.LANGUAGE_CD ,B.DESCR FROM PS_COMP_PROP_TBL A ,PS_COMP_PROP_LANG B WHERE A.PROPERTY_ID = B.PROPERTY_ID AND A.PROPERTY_CTGY = 'HE' OR A.PROPERTY_CTGY = 'VE' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROPERTY_ID | Character(10) | VARCHAR2(10) NOT NULL |
Property Code
Prompt Table: COMP_PROP_TBL |
2 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |