SP_MER_APPR_TMP (SQL Table)	Index Back
Group Review Result Temp Table Group Review Result Temp Table - this Temp Table contains fields of both the Employee Review table (EP_APPR) and the group result table (SAL_PLN_GRP_RES). The table is used to process Review Results of a Group of employees in the Merit Increase by Group.

SP_MER_APPR_TMP

(SQL Table)

Group Review Result Temp Table

Group Review Result Temp Table - this Temp Table contains fields of both the Employee Review table (EP_APPR) and the group result table (SAL_PLN_GRP_RES). The table is used to process Review Results of a Group of employees in the Merit Increase by Group.

Parent record: SAL_PLN_GRP_RES

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.

2 VERSIONGBQDM Number(10,0) DECIMAL(10) NOT NULL Version Number

3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

5 JOB_EFFDT Date(10) DATE Job Effective Date

6 JOB_EFFSEQ Number(3,0) SMALLINT NOT NULL Job Effective Sequence

7 PERIOD_BEGIN_DT Date(10) DATE Period Begin Date

8 PERIOD_END_DT Date(10) DATE Period End Date

9 EP_REVIEW_TYPE Character(8) VARCHAR2(8) NOT NULL Review type

10 EP_APPRAISAL_ID Number(8,0) INTEGER NOT NULL Document ID

11 EP_REVIEW_STATUS Character(4) VARCHAR2(4) NOT NULL This field tracks the status of a review document through it's life cycle. This is separate from the approval status of the review, which is tracked separately.
AK=Acknowledged
AR=Shared with Employee
CA=Canceled
CO=Completed
EC=Define Criteria
IP=Evaluation in Progress
NS=Not Started
PA=Approval
RH=Pending Acknowledgement
TP=Track Progress

12 EP_APPROVAL_STATUS Character(4) VARCHAR2(4) NOT NULL This field tracks the current approval status of a review. This is separate from the review's lifecycle status, which is tracked separately.
APRV=Approved
DENY=Denied
ERRO=Approval Error
NREQ=Not Required
OPEN=Not Submitted
SUBM=Submitted

13 EP_RATING Number(6,2) DECIMAL(5,2) NOT NULL Rating

14 RATING_MODEL Character(4) VARCHAR2(4) NOT NULL Rating Model

15 REVIEW_POINTS Number(3,0) SMALLINT NOT NULL Review Points

16 REVIEW_RATING Character(1) VARCHAR2(1) NOT NULL Review Rating

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GB_GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Group Build ID.
2	VERSIONGBQDM	Number(10,0)	DECIMAL(10) NOT NULL	Version Number
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
5	JOB_EFFDT	Date(10)	DATE	Job Effective Date
6	JOB_EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Job Effective Sequence
7	PERIOD_BEGIN_DT	Date(10)	DATE	Period Begin Date
8	PERIOD_END_DT	Date(10)	DATE	Period End Date
9	EP_REVIEW_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Review type
10	EP_APPRAISAL_ID	Number(8,0)	INTEGER NOT NULL	Document ID
11	EP_REVIEW_STATUS	Character(4)	VARCHAR2(4) NOT NULL	This field tracks the status of a review document through it's life cycle. This is separate from the approval status of the review, which is tracked separately. AK=Acknowledged AR=Shared with Employee CA=Canceled CO=Completed EC=Define Criteria IP=Evaluation in Progress NS=Not Started PA=Approval RH=Pending Acknowledgement TP=Track Progress
12	EP_APPROVAL_STATUS	Character(4)	VARCHAR2(4) NOT NULL	This field tracks the current approval status of a review. This is separate from the review's lifecycle status, which is tracked separately. APRV=Approved DENY=Denied ERRO=Approval Error NREQ=Not Required OPEN=Not Submitted SUBM=Submitted
13	EP_RATING	Number(6,2)	DECIMAL(5,2) NOT NULL	Rating
14	RATING_MODEL	Character(4)	VARCHAR2(4) NOT NULL	Rating Model
15	REVIEW_POINTS	Number(3,0)	SMALLINT NOT NULL	Review Points
16	REVIEW_RATING	Character(1)	VARCHAR2(1) NOT NULL	Review Rating