PEBGREV PERGRDS PERGRPA PERGRRA PERGRRE PTVGRTP PTVISTA

Model Employee Relations


Model Label : Banner HR Employee Relations Module
Path : BANNER DEV/HR/Employee Relations

List of Objects

Object Name Object Type Layer Name
PEBGREV TABLE Default
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
Server name MALDEV8_B60
Creation Date 04/15/2002 18:19:47:000

Table Columns informations

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

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
Server name MALDEV8_B60
Creation Date 04/15/2002 18:19:51:000

Table Columns informations

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

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

Text: Free form text description of the grievance.

Columns Comments for PERGRDS_ACTIVITY_DATE (3)

Source Code Comments

Activity Date: Date of last modification to the record.

Table PERGRPA

Schema Name PAYROLL
Server name MALDEV8_B60
Creation Date 04/15/2002 18:19:51:000

Table Columns informations

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_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

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
Server name MALDEV8_B60
Creation Date 04/15/2002 18:19:51:000

Table Columns informations

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

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
Server name MALDEV8_B60
Creation Date 04/15/2002 18:19:51:000

Table Columns informations

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

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

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

Columns Comments for PERGRRE_ACTIVITY_DATE (3)

Source Code Comments

Activity Date: Date of last modification to the record.

Table PTVGRTP

Schema Name PAYROLL
Server name MALDEV8_B60
Creation Date 04/15/2002 18:20:08:000

Table Columns informations

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

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
Server name MALDEV8_B60
Creation Date 04/15/2002 18:20:08:000

Table Columns informations

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

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