Les détails de l'objet sont les suivants :
Table associée : Change_Request
Sous-objets : par défaut
REL_ATTR : id
Nom comun : chg_ref_num
Groupe de fonctions : change_mgr
Opérations REST : CREATE READ UPDATE
|
Attribut |
Champ BdD |
Type de données |
Références SREL |
Indicateurs |
|---|---|---|---|---|
|
description |
description |
STRING |
|
|
|
actions |
actions |
STRING |
|
|
|
Activé |
active_flag |
NOMBRE ENTIER |
enum bool_tab |
REQUIRED |
|
active_prev |
LOCAL |
SREL |
bool.enum |
|
|
actual_comp_ date |
actual_comp_ date |
LOCAL_ TIME |
|
|
|
cost |
actual_cost |
NOMBRE ENTIER |
|
|
|
actual_total_ time |
actual_total_ time |
DUREE |
|
|
|
affected_contact |
affected_contact |
UUID |
ca_contact uuid |
REQUIRED |
|
Destinataire |
Destinataire |
UUID |
|
|
|
assignee_prev |
LOCAL |
SREL |
agt.id |
|
|
backout_plan |
backout_plan |
STRING |
|
|
|
business_case |
business_case |
STRING 4000 |
|
|
|
call_back_date |
call_back_date |
LOCAL_ TIME |
|
|
|
call_back_flag |
call_back_flag |
NOMBRE ENTIER |
|
|
|
catégorie |
catégorie |
STRING |
code chgcat |
|
|
category_prev |
LOCAL |
SREL |
chgcat.code |
|
|
cawf_procid |
cawf_procid |
STRING |
|
|
|
chg_ref_num |
chg_ref_num |
STRING |
|
UNIQUE REQUIRED S_KEY |
|
chgtype |
chgtype |
SREL |
chgtype.id |
|
|
close_date |
close_date |
LOCAL_TIME |
|
|
|
closure_code |
closure_code |
SREL |
|
|
|
created_via |
created_via |
NOMBRE ENTIER |
id d'interface |
|
|
effort |
effort |
STRING 4000 |
|
|
|
est_comp_date |
est_comp_date |
LOCAL_TIME |
|
|
|
est_cost |
est_cost |
NOMBRE ENTIER |
|
|
|
est_total_time |
est_total_time |
DUREE |
|
|
|
requested_by |
|
SREL |
cnt.id |
|
|
external_system_ticket |
|
STRING (4000) |
|
|
|
orig_user_dept |
|
SREL |
dept.id |
|
|
orig_user_organization |
|
SREL |
org.id |
|
|
orig_user_admin_org |
|
SREL |
org.id |
|
|
orig_user_cost_center |
|
SREL |
cost_cntr.id |
|
|
flag1 |
flag1 |
NOMBRE ENTIER |
|
|
|
flag2 |
flag2 |
NOMBRE ENTIER |
|
|
|
flag3 |
flag3 |
NOMBRE ENTIER |
|
|
|
flag4 |
flag4 |
NOMBRE ENTIER |
|
|
|
flag5 |
flag5 |
NOMBRE ENTIER |
|
|
|
flag6 |
flag6 |
NOMBRE ENTIER |
|
|
|
groupe |
group_id |
UUID |
|
|
|
group_prev |
LOCAL |
SREL |
grp.id |
|
|
id |
id |
NOMBRE ENTIER |
|
UNIQUE REQUIRED KEY |
|
impact |
impact |
NOMBRE ENTIER |
impact enum |
|
|
impact_prev |
LOCAL |
SREL |
imp.enum |
|
|
justification |
justification |
STRING 4000 |
|
Justification business |
|
last_mod_by |
last_mod_by |
UUID |
ca_contact uuid |
|
|
modified_date |
last_mod_dt |
LOCAL_TIME |
|
|
|
log_agent |
log_agent |
UUID |
ca_contact uuid |
REQUIRED |
|
macro_predicted_violation |
macro_predict_ viol |
NOMBRE ENTIER |
|
|
|
need_by |
need_by |
LOCAL_TIME |
|
|
|
open_date |
open_date |
LOCAL_TIME |
|
|
|
Organisation |
Organisation |
UUID |
uuid ca_organization |
|
|
orig_user_admin_org |
|
SREL |
Organisation |
|
|
orig_user_cost_center |
|
SREL |
cost_cntr |
|
|
orig_user_dept |
|
SREL |
dept |
|
|
orig_user_organization |
|
SREL |
Organisation |
|
|
Parent |
Parent |
NOMBRE ENTIER |
chg id |
|
|
persistent_id |
persid |
STRING |
|
|
|
person_ contacting |
person_ contacting |
NOMBRE ENTIER |
id perscon |
|
|
predicted_sla_ violation |
predicted_sla_ viol |
NOMBRE ENTIER |
|
|
|
priority |
priority |
NOMBRE ENTIER |
enum pri |
REQUIRED |
|
priority_prev |
LOCAL |
SREL |
pri.enum |
|
|
Produit |
Produit |
NOMBRE ENTIER |
id de produit |
|
|
reporting_ method |
reporting_ method |
NOMBRE ENTIER |
id repmeth |
|
|
requestor |
requestor |
UUID |
ca_contact uuid |
REQUIRED |
|
resolve_date |
resolve_date |
LOCAL_TIME |
|
|
|
risk |
risk |
SREL |
risk_level |
|
|
rootcause |
rootcause |
NOMBRE ENTIER |
id rootcause |
|
|
sched_start_date |
sched_start_date |
LOCAL_TIME |
|
|
|
sched_end_date |
sched_end_date |
LOCAL_TIME |
|
|
|
sched_duration |
sched_duration |
LOCAL_TIME |
|
|
|
service_date |
service_date |
LOCAL_TIME |
|
|
|
service_num |
service_num |
STRING |
|
|
|
sla_violation |
sla_violation |
NOMBRE ENTIER |
|
|
|
start_date |
start_date |
LOCAL_TIME |
|
|
|
status |
status |
STRING |
code chgstat |
|
|
status_prev |
LOCAL |
SREL |
chgstat.code |
|
|
Chaîne 1 |
Chaîne 1 |
STRING |
|
|
|
Chaîne 2 |
Chaîne 2 |
STRING |
|
|
|
Chaîne 3 |
Chaîne 3 |
STRING |
|
|
|
Chaîne 4 |
Chaîne 4 |
STRING |
|
|
|
Chaîne 5 |
Chaîne 5 |
STRING |
|
|
|
Chaîne 6 |
Chaîne 6 |
STRING |
|
|
|
submittedSurvey |
|
BREL |
risk_svy |
|
|
récapitulatif |
récapitulatif |
STRING |
|
|
|
support_lev |
support_lev |
STRING |
srv_desc code |
|
|
template_name |
template_name |
STRING |
chg_template template_name |
|
|
type_of_contact |
type_of_contact |
NOMBRE ENTIER |
id de type de contact |
|
|
Utilisateur 1 |
Utilisateur 1 |
STRING |
|
|
|
Utilisateur 2 |
Utilisateur 2 |
STRING |
|
|
|
Utilisateur 3 |
Utilisateur 3 |
STRING |
|
|
|
cab |
Cab |
UUID |
|
|
|
closure_code |
Closure_code |
NOMBRE ENTIER |
Closure_code.id |
|
|
cab_approval |
Cab_approval |
NOMBRE ENTIER |
Boolean.id |
|
|
target_times |
target_times |
BREL |
tgt_time_mapped_chg |
|
|
target_start_last |
target_start_last |
DATE |
|
|
|
target_hold_last |
target_hold_last |
DATE |
|
|
|
target_hold_count |
target_hold_count |
NOMBRE ENTIER |
|
|
|
target_resolved_last |
target_resolved_last |
DATE |
|
|
|
target_resolved_count |
target_resolved_count |
NOMBRE ENTIER |
|
|
|
target_closed_ |
target_closed_last |
DATE |
|
|
|
target_closed_ |
target_closed_count |
NOMBRE ENTIER |
|
|
|
close_date_prev |
close_date_prev |
LOCAL DATE |
|
|
|
resolve_date_ |
resolve_date_prev |
LOCAL DATE |
|
|
|
target_hold_ |
target_hold_count_prev |
LOCAL INTEGER |
|
|
|
target_resolved_count_prev |
target_resolved_count_prev |
LOCAL INTEGER |
|
|
|
target_closed_ |
target_closed_count_prev |
LOCAL INTEGER |
|
|
|
Copyright © 2013 CA.
Tous droits réservés.
|
|