PEBGREV PERGRDS PERGRPA PERGRRA PERGRRE PTVGRTP PTVISTA

Model Employee Relations


Model Label : Banner HR Employee Relations Module
Path : Default Folder/B70/payroll/Employee Relations

List of Objects

Object Name Object Type Layer Name
PEBGREV TABLE Main Objects
PERGRDS TABLE Default
PERGRPA TABLE Default
PERGRRA TABLE Default
PERGRRE TABLE Default
PTVGRTP TABLE Default
PTVISTA TABLE Default

Comments

Model View

''

Table PEBGREV

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
PEBGREV_NO PEBGREV_NO NUMBER(8,0) No *
PEBGREV_DESC PEBGREV_DESC VARCHAR2(60) No
PEBGREV_GRTP_CODE PEBGREV_GRTP_CODE VARCHAR2(4) No *
PEBGREV_ISTA_CODE PEBGREV_ISTA_CODE VARCHAR2(1) No *
PEBGREV_ISTA_DATE PEBGREV_ISTA_DATE DATE No
PEBGREV_FILED_DATE PEBGREV_FILED_DATE DATE No
PEBGREV_RESOLVED_DATE PEBGREV_RESOLVED_DATE DATE Yes
PEBGREV_ACTIVITY_DATE PEBGREV_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
PEBGREV_GRTP_CODE PTVGRTP_CODE PTVGRTP
PEBGREV_ISTA_CODE PTVISTA_CODE PTVISTA

Index

Index Name Index Type Column Name
PK_PEBGREV Unique PEBGREV_NO

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
PEBGREV SYNONYM S4B70.PUBLIC Rely on ()
PERGRPA TABLE S4B70.PAYROLL Refer( No Action )
PERGRRA TABLE S4B70.PAYROLL Refer( No Action )
CHECK_KEYS Forms Trigger BANNER7_FORMS.PEAGREV Use(select )
CHECK_KEYS Forms Trigger BANNER7_FORMS_10G.PEAGREV Use(select )
PTQGREV_RG Forms Record Group BANNER7_FORMS.PEAGREV Use(select )
PTQGREV_RG Forms Record Group BANNER7_FORMS.POQLIBR Use(select )
PTQGREV_RG Forms Record Group BANNER7_FORMS_10G.POQLIBR Use(select )
PTQGREV_RG Forms Record Group BANNER7_FORMS_10G.PEAGREV Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS.PTVGRTP.PTVGRTP Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS.PTVGRPT.PTVGRPT Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS.PTVGRSR.PTVGRSR Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.PTVGRTP.PTVGRTP Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.PTVGRSR.PTVGRSR Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.PTVGRPT.PTVGRPT Use(select )
PEBGREV Forms DataBlock BANNER7_FORMS.PEAGREV Rely on () Use(insert,update,delete,select )
PEBGREV Forms DataBlock BANNER7_FORMS_10G.PEAGREV Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

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

Comments

Source Code Comments

Grievance Table.

Columns Comments for PEBGREV_NO (1)

Source Code Comments

GREVIANCE NUMBER: Unique identification number of this grievance.

Columns Comments for PEBGREV_DESC (2)

Source Code Comments

DESC: Brief description of the grievance.

Columns Comments for PEBGREV_GRTP_CODE (3)

Source Code Comments

GRTP CODE: Grievance Type Code associated with the grievance.

Columns Comments for PEBGREV_ISTA_CODE (4)

Source Code Comments

ISTA CODE: Incident Status Code associated with the grievance.

Columns Comments for PEBGREV_ISTA_DATE (5)

Source Code Comments

ISTA DATE: Date the status was established.

Columns Comments for PEBGREV_FILED_DATE (6)

Source Code Comments

FILED DATE: Date the grievance was filed.

Columns Comments for PEBGREV_RESOLVED_DATE (7)

Source Code Comments

RESOLVED DATE: Date the grievance was resolved.

Columns Comments for PEBGREV_ACTIVITY_DATE (8)

Source Code Comments

ACTIVITY DATE: Date of last modification to the record.

Table PERGRDS

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
PERGRDS_GREV_NO PERGRDS_GREV_NO NUMBER(8,0) No
PERGRDS_TEXT PERGRDS_TEXT LONG Yes
PERGRDS_ACTIVITY_DATE PERGRDS_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
PERGRDS SYNONYM S4B70.PUBLIC Rely on ()
POST-DELETE Forms Trigger BANNER7_FORMS.PEAGREV.PEBGREV Use(delete )
POST-DELETE Forms Trigger BANNER7_FORMS_10G.PEAGREV.PEBGREV Use(delete )
PRE-INSERT Forms Trigger BANNER7_FORMS.PEAGREV.PERGRDS Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS_10G.PEAGREV.PERGRDS Use(select )
PERGRDS Forms DataBlock BANNER7_FORMS.PEAGREV Rely on () Use(insert,update,delete,select )
PERGRDS Forms DataBlock BANNER7_FORMS_10G.PEAGREV Rely on () Use(insert,update,delete,select )

Comments

Source Code Comments

Grievance Description Table

Columns Comments for PERGRDS_GREV_NO (1)

Source Code Comments

Grievance Number: Identification number of the grievance for this record.

Columns Comments for PERGRDS_TEXT (2)

Source Code Comments

Activity Date: Date of last modification to the record.

Columns Comments for PERGRDS_ACTIVITY_DATE (3)

Source Code Comments

Text: Free form text description of the grievance.

Table PERGRPA

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
PERGRPA_GREV_NO PERGRPA_GREV_NO NUMBER(8,0) No *
PERGRPA_PIDM PERGRPA_PIDM NUMBER(8,0) No *
PERGRPA_GRPT_CODE PERGRPA_GRPT_CODE VARCHAR2(4) No *
PERGRPA_POSN PERGRPA_POSN VARCHAR2(6) Yes *
PERGRPA_SUFF PERGRPA_SUFF VARCHAR2(2) Yes *
PERGRPA_GRIEVANT_IND PERGRPA_GRIEVANT_IND VARCHAR2(1) Yes
PERGRPA_ACTIVITY_DATE PERGRPA_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
PERGRPA_GRPT_CODE PTVGRPT_CODE PTVGRPT
PERGRPA_PIDM PEBEMPL_PIDM PEBEMPL
PERGRPA_GREV_NO PEBGREV_NO PEBGREV
PERGRPA_PIDM NBRBJOB_PIDM NBRBJOB
PERGRPA_POSN NBRBJOB_POSN NBRBJOB
PERGRPA_SUFF NBRBJOB_SUFF NBRBJOB

Index

Index Name Index Type Column Name
PERGRPA_KEY_INDEX PERGRPA_GREV_NO
PERGRPA_KEY_INDEX PERGRPA_PIDM

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
PERGRPA SYNONYM S4B70.PUBLIC Rely on ()
POST-DELETE Forms Trigger BANNER7_FORMS.PEAGREV.PEBGREV Use(delete )
POST-DELETE Forms Trigger BANNER7_FORMS_10G.PEAGREV.PEBGREV Use(delete )
PERGRPA Forms DataBlock BANNER7_FORMS.PEAGREV Rely on () Use(insert,update,delete,select )
PERGRPA Forms DataBlock BANNER7_FORMS_10G.PEAGREV Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PERGRPA_KEY_INDEX INDEX S4B70.PAYROLL Rely on ()
NBRBJOB TABLE S4B70.POSNCTL Refer( No Action )
PEBEMPL TABLE S4B70.PAYROLL Refer( No Action )
PEBGREV TABLE S4B70.PAYROLL Refer( No Action )
PTVGRPT TABLE S4B70.PAYROLL Refer( No Action )

Comments

Source Code Comments

Grievance Participants Table.

Columns Comments for PERGRPA_GREV_NO (1)

Source Code Comments

GREVIANCE NUMBER: Identification number of the grievance this record
is associated with.

Columns Comments for PERGRPA_PIDM (2)

Source Code Comments

PIDM: Identification number associated with a person.

Columns Comments for PERGRPA_GRPT_CODE (3)

Source Code Comments

GRPT CODE: Participant Type Code associated with this person.

Columns Comments for PERGRPA_POSN (4)

Source Code Comments

POSITION: The person's position associated with the grievance.

Columns Comments for PERGRPA_SUFF (5)

Source Code Comments

SUFFIX: Suffix associated with the position.

Columns Comments for PERGRPA_GRIEVANT_IND (6)

Source Code Comments

GRIEVANT INDICATOR: Indicates whether this person is the grievant.

Columns Comments for PERGRPA_ACTIVITY_DATE (7)

Source Code Comments

ACTIVITY DATE: Date of last modification to the record.

Table PERGRRA

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
PERGRRA_GREV_NO PERGRRA_GREV_NO NUMBER(8,0) No *
PERGRRA_GRSR_CODE PERGRRA_GRSR_CODE VARCHAR2(4) No *
PERGRRA_GRSR_DATE PERGRRA_GRSR_DATE DATE No
PERGRRA_ACTIVITY_DATE PERGRRA_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
PERGRRA_GRSR_CODE PTVGRSR_CODE PTVGRSR
PERGRRA_GREV_NO PEBGREV_NO PEBGREV

Index

Index Name Index Type Column Name
PERGRRA_KEY_INDEX PERGRRA_GREV_NO
PERGRRA_KEY_INDEX PERGRRA_GRSR_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
PERGRRA SYNONYM S4B70.PUBLIC Rely on ()
PERGRRA Forms DataBlock BANNER7_FORMS.PEAGREV Rely on () Use(insert,update,delete,select )
PERGRRA Forms DataBlock BANNER7_FORMS_10G.PEAGREV Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PERGRRA_KEY_INDEX INDEX S4B70.PAYROLL Rely on ()
PEBGREV TABLE S4B70.PAYROLL Refer( No Action )
PTVGRSR TABLE S4B70.PAYROLL Refer( No Action )

Comments

Source Code Comments

Grievance Resulting Actions Table

Columns Comments for PERGRRA_GREV_NO (1)

Source Code Comments

GRIEVANCE NUMBER: Identification number of the grievance this record
is associated with.

Columns Comments for PERGRRA_GRSR_CODE (2)

Source Code Comments

GRSR CODE: Grievance Standard Result Code associated with the grievance.

Columns Comments for PERGRRA_GRSR_DATE (3)

Source Code Comments

GRSR DATE: Date on which the result occurred.

Columns Comments for PERGRRA_ACTIVITY_DATE (4)

Source Code Comments

ACTIVITY DATE: Date of last modification to the record.

Table PERGRRE

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
PERGRRE_GREV_NO PERGRRE_GREV_NO NUMBER(8,0) No
PERGRRE_TEXT PERGRRE_TEXT LONG Yes
PERGRRE_ACTIVITY_DATE PERGRRE_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
PERGRRE SYNONYM S4B70.PUBLIC Rely on ()
PERGRRE Forms DataBlock BANNER7_FORMS.PEAGREV Rely on () Use(insert,update,delete,select )
PERGRRE Forms DataBlock BANNER7_FORMS_10G.PEAGREV Rely on () Use(insert,update,delete,select )

Comments

Source Code Comments

Grievance Resolution Table

Columns Comments for PERGRRE_GREV_NO (1)

Source Code Comments

Grievance Number: Identification number of the grievance for this record.

Columns Comments for PERGRRE_TEXT (2)

Source Code Comments

Activity Date: Date of last modification to the record.

Columns Comments for PERGRRE_ACTIVITY_DATE (3)

Source Code Comments

Text: Free form text description of the resolution of the grievance.

Table PTVGRTP

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
PTVGRTP_CODE PTVGRTP_CODE VARCHAR2(4) No *
PTVGRTP_DESC PTVGRTP_DESC VARCHAR2(30) No
PTVGRTP_ACTIVITY_DATE PTVGRTP_ACTIVITY_DATE DATE No

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_PTVGRTP Unique PTVGRTP_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
PTVGRTP SYNONYM S4B70.PUBLIC Rely on ()
PEBGREV TABLE S4B70.PAYROLL Refer( No Action )
POST-CHANGE Forms Trigger BANNER7_FORMS.PEAGREV.PEBGREV.PEBGREV_GRTP_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.PEAGREV.PEBGREV.PEBGREV_GRTP_CODE Use(select )
PTVGRTP_RG Forms Record Group BANNER7_FORMS.PEAGREV Use(select )
PTVGRTP_RG Forms Record Group BANNER7_FORMS_10G.POQLIBR Use(select )
PTVGRTP_RG Forms Record Group BANNER7_FORMS.POQLIBR Use(select )
PTVGRTP_RG Forms Record Group BANNER7_FORMS_10G.PEAGREV Use(select )
PTVGRTP Forms DataBlock BANNER7_FORMS.PTVGRTP Rely on () Use(insert,update,delete,select )
PTVGRTP Forms DataBlock BANNER7_FORMS_10G.PTVGRTP Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_PTVGRTP INDEX S4B70.PAYROLL Rely on ()

Comments

Source Code Comments

Grievance Type Validation Table

Columns Comments for PTVGRTP_CODE (1)

Source Code Comments

CODE: Code associated with this Grievance Type.

Columns Comments for PTVGRTP_DESC (2)

Source Code Comments

DESCRIPTION: Description of the Grievance Type.

Columns Comments for PTVGRTP_ACTIVITY_DATE (3)

Source Code Comments

ACTIVITY DATE: Date of last modification to the record.

Table PTVISTA

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
PTVISTA_CODE PTVISTA_CODE VARCHAR2(1) No *
PTVISTA_DESC PTVISTA_DESC VARCHAR2(30) No
PTVISTA_ACTIVITY_DATE PTVISTA_ACTIVITY_DATE DATE No

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_PTVISTA Unique PTVISTA_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
PTVISTA SYNONYM S4B70.PUBLIC Rely on ()
PEBGREV TABLE S4B70.PAYROLL Refer( No Action )
PEBHSIN TABLE S4B70.PAYROLL Refer( No Action )
POST-CHANGE Forms Trigger BANNER7_FORMS.PEAGREV.PEBGREV.PEBGREV_ISTA_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.PEIHSIT.PEBHSIN.PEBHSIN_ISTA_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.PEIHSIH.PERHSIH.PERHSIH_HSIN_NO Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.PEIHSIP.PERHSIP.PERHSIP_HSIN_NO Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.PEAHSIN.PEBHSIN.PEBHSIN_ISTA_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.PEAGREV.PEBGREV.PEBGREV_ISTA_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.PEAHSIN.PEBHSIN.PEBHSIN_ISTA_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.PEIHSIP.PERHSIP.PERHSIP_HSIN_NO Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.PEIHSIT.PEBHSIN.PEBHSIN_ISTA_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.PEIHSPS.PERHSIP.PERHSIP_HSIN_NO Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.PEIHSIH.PERHSIH.PERHSIH_HSIN_NO Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.PEIHSPS.PERHSIP.PERHSIP_HSIN_NO Use(select )
PTVISTA_RG Forms Record Group BANNER7_FORMS.PEAGREV Use(select )
PTVISTA_RG Forms Record Group BANNER7_FORMS_10G.PEAHSIN Use(select )
PTVISTA_RG Forms Record Group BANNER7_FORMS_10G.PEIHSIT Use(select )
PTVISTA_RG Forms Record Group BANNER7_FORMS_10G.POQLIBR Use(select )
PTVISTA_RG Forms Record Group BANNER7_FORMS.PEAHSIN Use(select )
PTVISTA_RG Forms Record Group BANNER7_FORMS_10G.PEAGREV Use(select )
PTVISTA_RG Forms Record Group BANNER7_FORMS.PEIHSIT Use(select )
PTVISTA_RG Forms Record Group BANNER7_FORMS.POQLIBR Use(select )
PTVISTA Forms DataBlock BANNER7_FORMS.PTVISTA Rely on () Use(insert,update,delete,select )
PTVISTA Forms DataBlock BANNER7_FORMS_10G.PTVISTA Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_PTVISTA INDEX S4B70.PAYROLL Rely on ()

Comments

Source Code Comments

Incident Status Validation Table

Columns Comments for PTVISTA_CODE (1)

Source Code Comments

CODE: Code associated with this incident status.

Columns Comments for PTVISTA_DESC (2)

Source Code Comments

DESCRIPTION: Description of the incident status.

Columns Comments for PTVISTA_ACTIVITY_DATE (3)

Source Code Comments

ACTIVITY DATE: Date of last modification to the record.

Link between PERGRPA and PEBGREV

Caller : PERGRPA
Called : PEBGREV

Link List

Link Type Link Project
Refer( No Action ) Link Foreign Key Between PERGRPA and PEBGREV PAYROLL

Link Foreign Key Between PERGRPA and PEBGREV

Caller : PERGRPA
Called : PEBGREV
Link Type : Refer( No Action )
Link : Link Foreign Key Between PERGRPA and PEBGREV

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
PERGRPA PERGRPA_GREV_NO PEBGREV_NO PEBGREV (1,1)-(0,n)

Comments

Link between PERGRRA and PEBGREV

Caller : PERGRRA
Called : PEBGREV

Link List

Link Type Link Project
Refer( No Action ) Link Foreign Key Between PERGRRA and PEBGREV PAYROLL

Link Foreign Key Between PERGRRA and PEBGREV

Caller : PERGRRA
Called : PEBGREV
Link Type : Refer( No Action )
Link : Link Foreign Key Between PERGRRA and PEBGREV

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
PERGRRA PERGRRA_GREV_NO PEBGREV_NO PEBGREV (1,1)-(0,n)

Comments

Link between PEBGREV and PTVGRTP

Caller : PEBGREV
Called : PTVGRTP

Link List

Link Type Link Project
Refer( No Action ) Link Foreign Key Between PEBGREV and PTVGRTP PAYROLL

Link Foreign Key Between PEBGREV and PTVGRTP

Caller : PEBGREV
Called : PTVGRTP
Link Type : Refer( No Action )
Link : Link Foreign Key Between PEBGREV and PTVGRTP

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
PEBGREV PEBGREV_GRTP_CODE PTVGRTP_CODE PTVGRTP (1,1)-(0,n)

Comments

Link between PEBGREV and PTVISTA

Caller : PEBGREV
Called : PTVISTA

Link List

Link Type Link Project
Refer( No Action ) Link Foreign Key Between PEBGREV and PTVISTA PAYROLL

Link Foreign Key Between PEBGREV and PTVISTA

Caller : PEBGREV
Called : PTVISTA
Link Type : Refer( No Action )
Link : Link Foreign Key Between PEBGREV and PTVISTA

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
PEBGREV PEBGREV_ISTA_CODE PTVISTA_CODE PTVISTA (1,1)-(0,n)

Comments