PEAPNHZ PEBHSIN PERHSCT PERHSFC PERHSID PERHSIH PERHSIM PERHSIP PERHSIT PERHSRA PTRHSIL PTVISTA

Model Employee Health And Safety


Model Label : Banner HR Employee Health And Safety Module

Path : Default Folder/B70/payroll/Employee Health And Safety

List of Objects

Object Name Object Type Layer Name
PEAPNHZ TABLE Default
PEBHSIN TABLE Main Objects
PERHSCT TABLE Default
PERHSFC TABLE Default
PERHSID TABLE Default
PERHSIH TABLE Default
PERHSIM TABLE Default
PERHSIP TABLE Default
PERHSIT TABLE Default
PERHSRA TABLE Default
PTRHSIL TABLE Default
PTVISTA TABLE Default

Comments

Model View

''

Table PEAPNHZ

Schema Name PAYROLL
Label PEAPNHZ
Server name S4B70
Creation Date 09/29/2003 12:16:12:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
PEAPNHZ_POSN PEAPNHZ_POSN VARCHAR2(6) No * *
PEAPNHZ_HAZD_CODE PEAPNHZ_HAZD_CODE VARCHAR2(4) No * *
PEAPNHZ_ACTIVITY_DATE PEAPNHZ_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
PEAPNHZ_HAZD_CODE PTRHAZD_CODE PTRHAZD
PEAPNHZ_POSN NBBPOSN_POSN NBBPOSN

Index

Index Name Index Type Column Name
PK_PEAPNHZ Unique PEAPNHZ_POSN
PK_PEAPNHZ Unique PEAPNHZ_HAZD_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
PEAPNHZ SYNONYM S4B70.PUBLIC Rely on ()
KEY-DELREC Forms Trigger BANNER7_FORMS.PTRHAZD.PTRHAZD Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.PTRHAZD.PTRHAZD Use(select )
PEAPNHZ Forms DataBlock BANNER7_FORMS.PEAPNHZ Rely on () Use(insert,update,delete,select )
PEAPNHZ Forms DataBlock BANNER7_FORMS_10G.PEAPNHZ Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_PEAPNHZ INDEX S4B70.PAYROLL Rely on ()
NBBPOSN TABLE S4B70.POSNCTL Refer( No Action )
PTRHAZD TABLE S4B70.PAYROLL Refer( No Action )

Comments

Source Code Comments

Health and Safety Position Hazard Rule Table

Columns Comments for PEAPNHZ_POSN (1)

Source Code Comments

POSITION: Position number associated with the hazard code.

Columns Comments for PEAPNHZ_HAZD_CODE (2)

Source Code Comments

HAZARD CODE: Hazard Code associated with the position.

Columns Comments for PEAPNHZ_ACTIVITY_DATE (3)

Source Code Comments

ACTIVITY DATE: Date of last modification to the record.

Table PEBHSIN

Schema Name PAYROLL
Label PEBHSIN
Server name S4B70
Creation Date 09/29/2003 12:16:12:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
PEBHSIN_NO PEBHSIN_NO NUMBER(8,0) No *
PEBHSIN_DESC PEBHSIN_DESC VARCHAR2(50) No
PEBHSIN_INCIDENT_DATE PEBHSIN_INCIDENT_DATE DATE No
PEBHSIN_HSIL_CODE PEBHSIN_HSIL_CODE VARCHAR2(6) Yes *
PEBHSIN_ISTA_CODE PEBHSIN_ISTA_CODE VARCHAR2(1) No *
PEBHSIN_ISTA_DATE PEBHSIN_ISTA_DATE DATE No
PEBHSIN_ACTIVITY_DATE PEBHSIN_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
PEBHSIN_ISTA_CODE PTVISTA_CODE PTVISTA
PEBHSIN_HSIL_CODE PTRHSIL_CODE PTRHSIL

Index

Index Name Index Type Column Name
PK_PEBHSIN Unique PEBHSIN_NO

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
sel_days_count C/C++ Function [F:\BANNER\C\PEROSHA.PC] Use(select )
sel_incident_date C/C++ Function [F:\BANNER\C\PERCAF7.PC] Use(select )
sel_incident_loc C/C++ Function [F:\BANNER\C\PEROSHA.PC] Use(select )
sel_medical C/C++ Function [F:\BANNER\C\PEROSHA.PC] Use(select )
PEBHSIN SYNONYM S4B70.PUBLIC Rely on ()
PERHSCT TABLE S4B70.PAYROLL Refer( No Action )
PERHSIH TABLE S4B70.PAYROLL Refer( No Action )
PERHSIM TABLE S4B70.PAYROLL Refer( No Action )
PERHSIP TABLE S4B70.PAYROLL Refer( No Action )
PERHSIT TABLE S4B70.PAYROLL Refer( No Action )
PERHSRA TABLE S4B70.PAYROLL Refer( No Action )
POST-CHANGE Forms Trigger BANNER7_FORMS.PEIHSIH.PERHSIH.PERHSIH_HSIN_NO Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.PEIHSPS.PERHSIP.PERHSIP_HSIN_NO Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.PEIHSIP.PERHSIP.PERHSIP_HSIN_NO Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.PEIHSPS.PERHSIP.PERHSIP_HSIN_NO Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.PEIHSIP.PERHSIP.PERHSIP_HSIN_NO Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.PEIHSIH.PERHSIH.PERHSIH_HSIN_NO Use(select )
CHECK_KEYS Forms Trigger BANNER7_FORMS.PEAHSIN Use(select )
CHECK_KEYS Forms Trigger BANNER7_FORMS_10G.PEAHSIN Use(select )
SPLIT_DATE_TIME Forms Trigger BANNER7_FORMS.PEAHSIN Use(select )
SPLIT_DATE_TIME Forms Trigger BANNER7_FORMS_10G.PEAHSIN Use(select )
UPDATE_INCIDENT_DATE Forms Trigger BANNER7_FORMS.PEAHSIN Use(update )
UPDATE_INCIDENT_DATE Forms Trigger BANNER7_FORMS_10G.PEAHSIN Use(update )
PTQHSIN_RG Forms Record Group BANNER7_FORMS.POQLIBR Use(select )
PTQHSIN_RG Forms Record Group BANNER7_FORMS.PEAHSIN Use(select )
PTQHSIN_RG Forms Record Group BANNER7_FORMS_10G.PEAHSIN Use(select )
PTQHSIN_RG Forms Record Group BANNER7_FORMS_10G.POQLIBR Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS.PTRHSIL.PTRHSIL Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.PTVISTA.PTVISTA Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.PTRHSIL.PTRHSIL Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS.PTVISTA.PTVISTA Use(select )
PEBHSIN Forms DataBlock BANNER7_FORMS.PEIHSIT Rely on () Use(select )
PEBHSIN Forms DataBlock BANNER7_FORMS_10G.PEIHSIT Rely on () Use(select )
PEBHSIN Forms DataBlock BANNER7_FORMS_10G.PEAHSIN Rely on () Use(insert,update,delete,select )
PEBHSIN Forms DataBlock BANNER7_FORMS.PEAHSIN Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_PEBHSIN INDEX S4B70.PAYROLL Rely on ()
PTRHSIL TABLE S4B70.PAYROLL Refer( No Action )
PTVISTA TABLE S4B70.PAYROLL Refer( No Action )

Comments

Source Code Comments

Health and Safety Incident Table

Columns Comments for PEBHSIN_NO (1)

Source Code Comments

NUMBER: Unique identification number associated with this record.

Columns Comments for PEBHSIN_DESC (2)

Source Code Comments

DESCRIPTION: Brief description of the incident.

Columns Comments for PEBHSIN_INCIDENT_DATE (3)

Source Code Comments

INCIDENT DATE: The date the incident took place.

Columns Comments for PEBHSIN_HSIL_CODE (4)

Source Code Comments

INCIDENT LOCATION CODE: Code associated with the location of the incident.

Columns Comments for PEBHSIN_ISTA_CODE (5)

Source Code Comments

STATUS: Indicates the status code of the incident.

Columns Comments for PEBHSIN_ISTA_DATE (6)

Source Code Comments

STATUS DATE: Indicates the date that the status was changed.

Columns Comments for PEBHSIN_ACTIVITY_DATE (7)

Source Code Comments

ACTIVITY DATE: Date of last modification to the record.

Table PERHSCT

Schema Name PAYROLL
Label PERHSCT
Server name S4B70
Creation Date 09/29/2003 12:16:15:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
PERHSCT_HSIN_NO PERHSCT_HSIN_NO NUMBER(8,0) No * *
PERHSCT_PIDM PERHSCT_PIDM NUMBER(8,0) No *
PERHSCT_HSCR_CODE PERHSCT_HSCR_CODE VARCHAR2(4) No * *
PERHSCT_COST PERHSCT_COST NUMBER(12,2) No
PERHSCT_ACTIVITY_DATE PERHSCT_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
PERHSCT_HSIN_NO PEBHSIN_NO PEBHSIN
PERHSCT_HSCR_CODE PTVHSCR_CODE PTVHSCR

Index

Index Name Index Type Column Name
PK_PERHSCT Unique PERHSCT_HSIN_NO
PK_PERHSCT Unique PERHSCT_PIDM
PK_PERHSCT Unique PERHSCT_HSCR_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
PERHSCT SYNONYM S4B70.PUBLIC Rely on ()
POST-CHANGE Forms Trigger BANNER7_FORMS.PEIHSIH.PERHSIH.PERHSIH_HSIN_NO Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.PEIHSIH.PERHSIH.PERHSIH_HSIN_NO Use(select )
CALC_PERSON_COST Forms Trigger BANNER7_FORMS.PEAHSIN Use(select )
CALC_PERSON_COST Forms Trigger BANNER7_FORMS_10G.PEAHSIN Use(select )
CALC_TOTAL_COST Forms Trigger BANNER7_FORMS.PEAHSIN Use(select )
CALC_TOTAL_COST Forms Trigger BANNER7_FORMS_10G.PEAHSIN Use(select )
GET_COSTS Forms Trigger BANNER7_FORMS.PEIHSIT Use(select )
GET_COSTS Forms Trigger BANNER7_FORMS_10G.PEIHSIT Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS.PEAHSIN.PEBHSIN Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS.PTVHSCR.PTVHSCR Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.PTVHSCR.PTVHSCR Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.PEAHSIN.PEBHSIN Use(select )
PRE-DELETE Forms Trigger BANNER7_FORMS.PEAHSIN.PEBHSIN Use(delete )
PRE-DELETE Forms Trigger BANNER7_FORMS_10G.PEAHSIN.PEBHSIN Use(delete )
PRE-DELETE Forms Trigger BANNER7_FORMS.PEAHSIN.PERHSIP Use(delete )
PRE-DELETE Forms Trigger BANNER7_FORMS_10G.PEAHSIN.PERHSIP Use(delete )
PERHSCT Forms DataBlock BANNER7_FORMS.PEAHSIN Rely on () Use(insert,update,delete,select )
PERHSCT Forms DataBlock BANNER7_FORMS_10G.PEAHSIN Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_PERHSCT INDEX S4B70.PAYROLL Rely on ()
PEBHSIN TABLE S4B70.PAYROLL Refer( No Action )
PTVHSCR TABLE S4B70.PAYROLL Refer( No Action )

Comments

Source Code Comments

Health and Safety Incident Costs Table

Columns Comments for PERHSCT_HSIN_NO (1)

Source Code Comments

INCIDENT NUMBER: Identification number of the incident this record
is associated with.

Columns Comments for PERHSCT_PIDM (2)

Source Code Comments

PIDM: Identification number associated with a person.

Columns Comments for PERHSCT_HSCR_CODE (3)

Source Code Comments

HSCR CODE: Cost Reason Code associated with this person.

Columns Comments for PERHSCT_COST (4)

Source Code Comments

COST: Dollar amount spent for this cost reason code regarding this person
and incident.

Columns Comments for PERHSCT_ACTIVITY_DATE (5)

Source Code Comments

ACTIVITY DATE: Date of last modification to the record.

Table PERHSFC

Schema Name PAYROLL
Label PERHSFC
Server name S4B70
Creation Date 09/29/2003 12:16:15:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
PERHSFC_HSIN_NO PERHSFC_HSIN_NO NUMBER(8,0) No
PERHSFC_TEXT PERHSFC_TEXT LONG Yes
PERHSFC_ACTIVITY_DATE PERHSFC_ACTIVITY_DATE DATE No

Foreign Key information

No Foreign Key

Index

No Result

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
sel_resolution C/C++ Function [F:\BANNER\C\PERCAF7.PC] Use(select )
PERHSFC SYNONYM S4B70.PUBLIC Rely on ()
KEY-CQUERY Forms Trigger BANNER7_FORMS.PEAHSIN.PERHSFC Use(select )
KEY-CQUERY Forms Trigger BANNER7_FORMS_10G.PEAHSIN.PERHSFC Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS.PEAHSIN.PEBHSIN Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.PEAHSIN.PEBHSIN Use(select )
PRE-DELETE Forms Trigger BANNER7_FORMS.PEAHSIN.PEBHSIN Use(delete )
PRE-DELETE Forms Trigger BANNER7_FORMS_10G.PEAHSIN.PEBHSIN Use(delete )
PRE-INSERT Forms Trigger BANNER7_FORMS.PEAHSIN.PERHSFC Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS_10G.PEAHSIN.PERHSFC Use(select )
PERHSFC Forms DataBlock BANNER7_FORMS.PEAHSIN Rely on () Use(insert,update,delete,select )
PERHSFC Forms DataBlock BANNER7_FORMS_10G.PEAHSIN Rely on () Use(insert,update,delete,select )

Comments

Source Code Comments

Health and Safety Incident Table.

Columns Comments for PERHSFC_HSIN_NO (1)

Source Code Comments

INCIDENT NUMBER: Identification number of the incident this record is associated with.

Columns Comments for PERHSFC_TEXT (2)

Source Code Comments

ACTIVITY DATE: Date the record was inserted or last updated.

Columns Comments for PERHSFC_ACTIVITY_DATE (3)

Source Code Comments

TEXT: Free form text description.

Table PERHSID

Schema Name PAYROLL
Label PERHSID
Server name S4B70
Creation Date 09/29/2003 12:16:15:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
PERHSID_HSIN_NO PERHSID_HSIN_NO NUMBER(8,0) No
PERHSID_TEXT PERHSID_TEXT LONG Yes
PERHSID_ACTIVITY_DATE PERHSID_ACTIVITY_DATE DATE No

Foreign Key information

No Foreign Key

Index

No Result

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
sel_description C/C++ Function [F:\BANNER\C\PERCAF7.PC] Use(select )
PERHSID SYNONYM S4B70.PUBLIC Rely on ()
KEY-CQUERY Forms Trigger BANNER7_FORMS.PEAHSIN.PERHSID Use(select )
KEY-CQUERY Forms Trigger BANNER7_FORMS_10G.PEAHSIN.PERHSID Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS.PEAHSIN.PEBHSIN Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.PEAHSIN.PEBHSIN Use(select )
PRE-DELETE Forms Trigger BANNER7_FORMS.PEAHSIN.PEBHSIN Use(delete )
PRE-DELETE Forms Trigger BANNER7_FORMS_10G.PEAHSIN.PEBHSIN Use(delete )
PRE-INSERT Forms Trigger BANNER7_FORMS.PEAHSIN.PERHSID Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS_10G.PEAHSIN.PERHSID Use(select )
PERHSID Forms DataBlock BANNER7_FORMS.PEAHSIN Rely on () Use(insert,update,delete,select )
PERHSID Forms DataBlock BANNER7_FORMS_10G.PEAHSIN Rely on () Use(insert,update,delete,select )

Comments

Source Code Comments

Incident Comments Table.

Columns Comments for PERHSID_HSIN_NO (1)

Source Code Comments

INCIDENT NUMBER: Identification number of the incident this record is associated with.

Columns Comments for PERHSID_TEXT (2)

Source Code Comments

ACTIVITY DATE: Date the record was inserted or last updated.

Columns Comments for PERHSID_ACTIVITY_DATE (3)

Source Code Comments

TEXT: Free form text description.

Table PERHSIH

Schema Name PAYROLL
Label PERHSIH
Server name S4B70
Creation Date 09/29/2003 12:16:15:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
PERHSIH_HSIN_NO PERHSIH_HSIN_NO NUMBER(8,0) No * *
PERHSIH_HAZD_CODE PERHSIH_HAZD_CODE VARCHAR2(4) No * *
PERHSIH_ACTIVITY_DATE PERHSIH_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
PERHSIH_HSIN_NO PEBHSIN_NO PEBHSIN
PERHSIH_HAZD_CODE PTRHAZD_CODE PTRHAZD

Index

Index Name Index Type Column Name
PK_PERHSIH Unique PERHSIH_HSIN_NO
PK_PERHSIH Unique PERHSIH_HAZD_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
PERHSIH SYNONYM S4B70.PUBLIC Rely on ()
KEY-DELREC Forms Trigger BANNER7_FORMS.PEAHSIN.PEBHSIN Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS.PTRHAZD.PTRHAZD Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.PTRHAZD.PTRHAZD Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.PEAHSIN.PEBHSIN Use(select )
PRE-DELETE Forms Trigger BANNER7_FORMS.PEAHSIN.PEBHSIN Use(delete )
PRE-DELETE Forms Trigger BANNER7_FORMS_10G.PEAHSIN.PEBHSIN Use(delete )
PERHSIH Forms DataBlock BANNER7_FORMS.PEIHSIH Rely on () Use(insert,update,delete,select )
PERHSIH Forms DataBlock BANNER7_FORMS.PEAHSIN Rely on () Use(insert,update,delete,select )
PERHSIH Forms DataBlock BANNER7_FORMS_10G.PEIHSIH Rely on () Use(insert,update,delete,select )
PERHSIH Forms DataBlock BANNER7_FORMS_10G.PEAHSIN Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_PERHSIH INDEX S4B70.PAYROLL Rely on ()
PEBHSIN TABLE S4B70.PAYROLL Refer( No Action )
PTRHAZD TABLE S4B70.PAYROLL Refer( No Action )

Comments

Source Code Comments

Health and Safety Incident Hazard Table

Columns Comments for PERHSIH_HSIN_NO (1)

Source Code Comments

INCIDENT NUMBER: Identification number of the incident this record is associated with.

Columns Comments for PERHSIH_HAZD_CODE (2)

Source Code Comments

HAZARD CODE: Hazard Code associated with the incident.

Columns Comments for PERHSIH_ACTIVITY_DATE (3)

Source Code Comments

ACTIVITY DATE: Date of last modification to the record.

Table PERHSIM

Schema Name PAYROLL
Label PERHSIM
Server name S4B70
Creation Date 10/28/2003 16:03:06:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
PERHSIM_HSIN_NO PERHSIM_HSIN_NO NUMBER(8,0) No * *
PERHSIM_PIDM PERHSIM_PIDM NUMBER(8,0) No *
PERHSIM_HSME_CODE PERHSIM_HSME_CODE VARCHAR2(4) No * *
PERHSIM_BEGIN_DATE PERHSIM_BEGIN_DATE DATE No *
PERHSIM_END_DATE PERHSIM_END_DATE DATE Yes
PERHSIM_PRIMARY_IND PERHSIM_PRIMARY_IND VARCHAR2(1) Yes
PERHSIM_HOURS_LOST PERHSIM_HOURS_LOST NUMBER(5,1) Yes
PERHSIM_HOURS_WORK_RESTRICTED PERHSIM_HOURS_WORK_RESTRICTED NUMBER(5,1) Yes
PERHSIM_ACTIVITY_DATE PERHSIM_ACTIVITY_DATE DATE No
PERHSIM_CLASSIFICATION_TYPE PERHSIM_CLASSIFICATION_TYPE VARCHAR2(1) No
PERHSIM_INJURY_ILLNESS_TYPE PERHSIM_INJURY_ILLNESS_TYPE VARCHAR2(1) No

Foreign Key information

Column name is Foreign Key For Column on Table
PERHSIM_HSIN_NO PEBHSIN_NO PEBHSIN
PERHSIM_HSME_CODE PTRHSME_CODE PTRHSME

Index

Index Name Index Type Column Name
PK_PERHSIM Unique PERHSIM_HSIN_NO
PK_PERHSIM Unique PERHSIM_PIDM
PK_PERHSIM Unique PERHSIM_HSME_CODE
PK_PERHSIM Unique PERHSIM_BEGIN_DATE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
sel_days_count C/C++ Function [F:\BANNER\C\PEROSHA.PC] Use(select )
sel_errors1 C/C++ Function [F:\BANNER\C\PEROSHA.PC] Use(select )
sel_errors2 C/C++ Function [F:\BANNER\C\PEROSHA.PC] Use(select )
sel_hours C/C++ Function [F:\BANNER\C\PERCAF7.PC] Use(select )
sel_leave_dates C/C++ Function [F:\BANNER\C\PERCAF7.PC] Use(select )
sel_medical C/C++ Function [F:\BANNER\C\PERCAF7.PC] Use(select )
sel_medical C/C++ Function [F:\BANNER\C\PEROSHA.PC] Use(select )
PERHSIM SYNONYM S4B70.PUBLIC Rely on ()
CHECK_PRIMARY_MED Forms Trigger BANNER7_FORMS.PEAHSIN Use(select )
CHECK_PRIMARY_MED Forms Trigger BANNER7_FORMS_10G.PEAHSIN Use(select )
POST-FORMS-COMMIT Forms Trigger BANNER7_FORMS.PEAHSIN Use(select )
POST-FORMS-COMMIT Forms Trigger BANNER7_FORMS_10G.PEAHSIN Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS.PEAHSIN.PEBHSIN Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS.PTRHSME.PTRHSME Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.PEAHSIN.PEBHSIN Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.PTRHSME.PTRHSME Use(select )
PRE-DELETE Forms Trigger BANNER7_FORMS.PEAHSIN.PEBHSIN Use(delete )
PRE-DELETE Forms Trigger BANNER7_FORMS_10G.PEAHSIN.PERHSIP Use(delete )
PRE-DELETE Forms Trigger BANNER7_FORMS.PEAHSIN.PERHSIP Use(delete )
PRE-DELETE Forms Trigger BANNER7_FORMS_10G.PEAHSIN.PEBHSIN Use(delete )
PERHSIM Forms DataBlock BANNER7_FORMS.PEAHSIN Rely on () Use(insert,update,delete,select )
PERHSIM Forms DataBlock BANNER7_FORMS_10G.PEAHSIN Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_PERHSIM INDEX S4B70.PAYROLL Rely on ()
PEBHSIN TABLE S4B70.PAYROLL Refer( No Action )
PTRHSME TABLE S4B70.PAYROLL Refer( No Action )

Comments

Source Code Comments

Health and Safety Incident Medical Table

Columns Comments for PERHSIM_HSIN_NO (1)

Source Code Comments

INCIDENT NUMBER: Identification number of the incident this record
is associated with.

Columns Comments for PERHSIM_PIDM (2)

Source Code Comments

PIDM: Identification number associated with a person.

Columns Comments for PERHSIM_HSME_CODE (3)

Source Code Comments

MEDICAL CODE: Medical Code associated with an illness or injury.

Columns Comments for PERHSIM_BEGIN_DATE (4)

Source Code Comments

BEGIN DATE: Date when the injury occurred or the illness began (or was
diagnosed).

Columns Comments for PERHSIM_END_DATE (5)

Source Code Comments

END DATE: Date when the injury or illness ceased to
be of consequence.

Columns Comments for PERHSIM_PRIMARY_IND (6)

Source Code Comments

PRIMARY INDICATOR: Indicates whether it is the primary illness or injury.

Columns Comments for PERHSIM_HOURS_LOST (7)

Source Code Comments

HOURS LOST: Number of hours lost due to this illness or injury.

Columns Comments for PERHSIM_HOURS_WORK_RESTRICTED (8)

Source Code Comments

HOURS WORK RESTRICTED: Number of hours when the employee's work is restricted
due to the illness or injury.

Columns Comments for PERHSIM_ACTIVITY_DATE (9)

Source Code Comments

ACTIVITY DATE: Date of last modification to the record.

Columns Comments for PERHSIM_CLASSIFICATION_TYPE (10)

Source Code Comments

Classification: D = Death A = Away days from work J = Job transfer or restriction O = Other recordable cases N = None

Columns Comments for PERHSIM_INJURY_ILLNESS_TYPE (11)

Source Code Comments

Injury and Illness Type: N = None I = Injuries S = Skin disorders R = Respiratory conditions P = Poisonings H = Hearing Loss A = All other illnesses

Table PERHSIP

Schema Name PAYROLL
Label PERHSIP
Server name S4B70
Creation Date 09/29/2003 12:16:15:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
PERHSIP_HSIN_NO PERHSIP_HSIN_NO NUMBER(8,0) No * *
PERHSIP_PIDM PERHSIP_PIDM NUMBER(8,0) No *
PERHSIP_HSPC_CODE PERHSIP_HSPC_CODE VARCHAR2(4) No * *
PERHSIP_POSN PERHSIP_POSN VARCHAR2(6) Yes
PERHSIP_SUFF PERHSIP_SUFF VARCHAR2(2) Yes
PERHSIP_DISA_CODE PERHSIP_DISA_CODE VARCHAR2(6) Yes *
PERHSIP_WORK_COMP_IND PERHSIP_WORK_COMP_IND VARCHAR2(1) Yes
PERHSIP_OSHA_IND PERHSIP_OSHA_IND VARCHAR2(1) Yes
PERHSIP_LITG_CODE PERHSIP_LITG_CODE VARCHAR2(1) Yes *
PERHSIP_LITG_DATE PERHSIP_LITG_DATE DATE Yes
PERHSIP_DEAD_IND PERHSIP_DEAD_IND VARCHAR2(1) Yes
PERHSIP_COMMENT PERHSIP_COMMENT LONG Yes
PERHSIP_ACTIVITY_DATE PERHSIP_ACTIVITY_DATE DATE No
PERHSIP_OSHA_RPT_DISPLAY_TYPE PERHSIP_OSHA_RPT_DISPLAY_TYPE VARCHAR2(1) No

Foreign Key information

Column name is Foreign Key For Column on Table
PERHSIP_HSIN_NO PEBHSIN_NO PEBHSIN
PERHSIP_DISA_CODE PTVDISA_CODE PTVDISA
PERHSIP_HSPC_CODE PTVHSPC_CODE PTVHSPC
PERHSIP_LITG_CODE PTVLITG_CODE PTVLITG

Index

Index Name Index Type Column Name
PK_PERHSIP Unique PERHSIP_HSIN_NO
PK_PERHSIP Unique PERHSIP_PIDM
PK_PERHSIP Unique PERHSIP_HSPC_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
check_multiple_persons C/C++ Function [F:\BANNER\C\PEROSHA.PC] Use(select )
sel_involved_people C/C++ Function [F:\BANNER\C\PERCAF7.PC] Use(select )
sel_medical C/C++ Function [F:\BANNER\C\PERCAF7.PC] Use(select )
sel_medical C/C++ Function [F:\BANNER\C\PEROSHA.PC] Use(select )
PERHSIP SYNONYM S4B70.PUBLIC Rely on ()
SPRIDEN TABLE S4B70.SATURN Join
KEY-LISTVAL Forms Trigger BANNER7_FORMS.PEAHSIN.PERHSIP.ID Use(select )
KEY-LISTVAL Forms Trigger BANNER7_FORMS_10G.PEAHSIN.PERHSIP.ID Use(select )
PTQHSIP_RG Forms Record Group BANNER7_FORMS.POQLIBR Use(select )
PTQHSIP_RG Forms Record Group BANNER7_FORMS.PEAHSIN Use(select )
PTQHSIP_RG Forms Record Group BANNER7_FORMS_10G.POQLIBR Use(select )
PTQHSIP_RG Forms Record Group BANNER7_FORMS_10G.PEAHSIN Use(select )
CHECK_KEYS Forms Trigger BANNER7_FORMS.PEIHSIP.KEY_BLOCK Use(select )
CHECK_KEYS Forms Trigger BANNER7_FORMS_10G.PEIHSIP.KEY_BLOCK Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS.PTVHSPC.PTVHSPC Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.PTVLITG.PTVLITG Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.PTVDISA.PTVDISA Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.PTVHSPC.PTVHSPC Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.PEAHSIN.PEBHSIN Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS.PEAHSIN.PEBHSIN Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS.PTVDISA.PTVDISA Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS.PTVLITG.PTVLITG Use(select )
PRE-DELETE Forms Trigger BANNER7_FORMS.PEAHSIN.PEBHSIN Use(delete )
PRE-DELETE Forms Trigger BANNER7_FORMS_10G.PEAHSIN.PEBHSIN Use(delete )
PERHSIP Forms DataBlock BANNER7_FORMS.PEIHSPS Rely on () Use(update,select )
PERHSIP Forms DataBlock BANNER7_FORMS.PEIHSIP Rely on () Use(insert,update,delete,select )
PERHSIP Forms DataBlock BANNER7_FORMS_10G.PEIHSPS Rely on () Use(update,select )
PERHSIP Forms DataBlock BANNER7_FORMS_10G.PEAHSIN Rely on () Use(insert,update,delete,select )
PERHSIP Forms DataBlock BANNER7_FORMS_10G.PEIHSIP Rely on () Use(insert,update,delete,select )
PERHSIP Forms DataBlock BANNER7_FORMS.PEAHSIN Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_PERHSIP INDEX S4B70.PAYROLL Rely on ()
PEBHSIN TABLE S4B70.PAYROLL Refer( No Action )
PTVDISA TABLE S4B70.PAYROLL Refer( No Action )
PTVHSPC TABLE S4B70.PAYROLL Refer( No Action )
PTVLITG TABLE S4B70.PAYROLL Refer( No Action )

Comments

Source Code Comments

Health and Safety Incident Partys Table

Columns Comments for PERHSIP_HSIN_NO (1)

Source Code Comments

INCIDENT NUMBER: Identification number of the incident this record is associated with.

Columns Comments for PERHSIP_PIDM (2)

Source Code Comments

PIDM: Identification number associated with a person.

Columns Comments for PERHSIP_HSPC_CODE (3)

Source Code Comments

HSPC CODE: Party Classification Code associated with this person.

Columns Comments for PERHSIP_POSN (4)

Source Code Comments

POSITION: Position which the person was in during the incident.

Columns Comments for PERHSIP_SUFF (5)

Source Code Comments

SUFFIX: Suffix associated with the position that the person was in during the incident.

Columns Comments for PERHSIP_DISA_CODE (6)

Source Code Comments

DISABILITY CODE: Indicates if the person is on disability and if so, what type of disability.

Columns Comments for PERHSIP_WORK_COMP_IND (7)

Source Code Comments

WORKERS COMP INDICATOR: Indicates whether the person received worker's compensation as a result of the incident.

Columns Comments for PERHSIP_OSHA_IND (8)

Source Code Comments

OSHA INDICATOR: Indicates whether the incident is OSHA reportable for this person.

Columns Comments for PERHSIP_LITG_CODE (9)

Source Code Comments

LITIGATION STATUS CODE: Indicates the status of litigation for this person.

Columns Comments for PERHSIP_LITG_DATE (10)

Source Code Comments

LITIGATION STATUS DATE: The date the litigation status was established.

Columns Comments for PERHSIP_DEAD_IND (11)

Source Code Comments

DEAD INDICATOR: Indicates if the referenced incident caused the person to die.

Columns Comments for PERHSIP_COMMENT (12)

Source Code Comments

OSHA Report Display: Determine what is displayed on report; B = Both Name and Job Title O = Only Name J = Job Title Only P = Privacy Case

Columns Comments for PERHSIP_ACTIVITY_DATE (13)

Source Code Comments

ACTIVITY DATE: Date of last modification to the record.

Columns Comments for PERHSIP_OSHA_RPT_DISPLAY_TYPE (14)

Source Code Comments

COMMENT: Brief comment regarding this person.

Table PERHSIT

Schema Name PAYROLL
Label PERHSIT
Server name S4B70
Creation Date 09/29/2003 12:16:16:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
PERHSIT_HSIN_NO PERHSIT_HSIN_NO NUMBER(8,0) No * *
PERHSIT_HSTC_CODE PERHSIT_HSTC_CODE VARCHAR2(6) No * *
PERHSIT_ACTIVITY_DATE PERHSIT_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
PERHSIT_HSIN_NO PEBHSIN_NO PEBHSIN
PERHSIT_HSTC_CODE PTVHSTC_CODE PTVHSTC

Index

Index Name Index Type Column Name
PK_PERHSIT Unique PERHSIT_HSIN_NO
PK_PERHSIT Unique PERHSIT_HSTC_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
PERHSIT SYNONYM S4B70.PUBLIC Rely on ()
KEY-DELREC Forms Trigger BANNER7_FORMS.PEAHSIN.PEBHSIN Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS.PTVHSTC.PTVHSTC Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.PTVHSTC.PTVHSTC Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.PEAHSIN.PEBHSIN Use(select )
PRE-DELETE Forms Trigger BANNER7_FORMS.PEAHSIN.PEBHSIN Use(delete )
PRE-DELETE Forms Trigger BANNER7_FORMS_10G.PEAHSIN.PEBHSIN Use(delete )
PEBHSIN Forms DataBlock BANNER7_FORMS.PEIHSIT Use(select )
PEBHSIN Forms DataBlock BANNER7_FORMS_10G.PEIHSIT Use(select )
PERHSIT Forms DataBlock BANNER7_FORMS.PEAHSIN Rely on () Use(insert,update,delete,select )
PERHSIT Forms DataBlock BANNER7_