sp_objid | part_num | objid | Generic part internal record number | |
mod_objid | mod_level | objid | Generic part revision internal record number | |
sp_id | part_num | part_number | Part number/name of the generic part | |
sp_notes | part_num | notes | Comments about the generic part | |
sp_desc | part_num | description | Description of the part | |
prog_type | part_num | prog_type | If support program, indicates whether program is site-based or product-based; i.e., 0=product, 1=site, default=0 | |
is_sppt_prog | part_num | is_sppt_prog | Indicates application category of the part: i.e., 0=physical part, 1=service part, 2=product literature | |
p_standalone | part_num | p_standalone | Indicates whether the part MAY receive standalone pricing; i.e. 0=no, 1=yes, default=0 | |
p_as_parent | part_num | p_as_parent | Indicates whether the part MAY be priced with options under it; i.e. 0=no, 1=yes, default=0 | |
p_as_child | part_num | p_as_child | Indicates whether the part MAY be priced as an option; i.e. 0=no, 1=yes, default=0 | |
mod_active | mod_level | active | Active/inactive/obsolete | |
mod_eff_date | mod_level | eff_date | The date the support program version becomes effective | |
mod_end_date | mod_level | end_date | The date the support program version expires | |
ent_type | entitlement | type | The type of service | |
delivery_type | entitlement | delivery_type | How consumption of the service is measured: i.e., 0=by unit (e.g., incident); 1=by duration (e.g., month) | |
category | entitlement | category | Service category; i.e., 0=product-based, 1=site-based, 2=stand alone | |
resp_time | entitlement | response_time | The committed response time for the entitlement in seconds | |
cov_hr_title | wk_work_hr | title | Name of the business calendar which has the entitled service hours | |
cov_hr_desc | wk_work_hr | description | Detailed description of the business calendar which has the entitled service hours | |
objid | entitlement | objid | Entitlement internat record number | 3 (UNIQUE) |
ctgry_name | entitlement | ctgry_name | Translates category | |