EP_APPR_STATUS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EP_APPRAISAL_ID	Number(8,0)	INTEGER NOT NULL	Document ID
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
4	PERIOD_BEGIN_DT	Date(10)	DATE NOT NULL	Period Begin Date
5	PERIOD_END_DT	Date(10)	DATE NOT NULL	Period End Date
6	EP_REVIEW_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Review type Prompt Table: EP_REVW_TYP_VW
7	EP_TEMPLATE_ID	Character(8)	VARCHAR2(8) NOT NULL	Template unique identifier Prompt Table: EP_TMPL_DEFN
8	EP_TMPL_EFFDT	Date(10)	DATE NOT NULL	Review Template Effective Date
9	CREATION_DT	Date(10)	DATE NOT NULL	Creation Date Default Value: %Date
10	EP_EST_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Translate field that determines the state (status) of the establish criteria step. CO=Completed IP=In Progress NA=Not Applicable NS=Not Started Default Value: NA
11	EP_EST_DUE_DATE	Date(10)	DATE	Date the establish criteria step is due to be completed.
12	EP_NOM_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Translate field that determines the state (status) of the nominate participants step. CO=Completed IP=In Progress NA=Not Applicable NS=Not Started Default Value: NA
13	EP_NOM_DUE_DATE	Date(10)	DATE	Date the nominate participants step is due to be completed.
14	EP_TRK_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Translate field that determines the state (status) of the track participants step. CO=Completed IP=In Progress NA=Not Applicable NS=Not Started Default Value: NA
15	EP_PRT_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Translate field that determines the state (status) of the review participants feedback step. CO=Completed IP=In Progress NA=Not Applicable NS=Not Started Default Value: NA
16	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=Available for Review CA=Cancelled CO=Completed IP=In Progress NS=Not Started RH=Review Held Default Value: IP
17	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 Default Value: OPEN
18	EP_REVIEW_ID	Character(8)	VARCHAR2(8) NOT NULL	Review ID Prompt Table: EP_REV_DEF_VW
19	EP_ROUNDING_RULE	Character(1)	VARCHAR2(1) NOT NULL	Used to determine how the review rating will be rounded to the maximum decimal point. D=Round Down S=Standard Rounding U=Round Up Default Value: S
20	EP_DEC_PLACES	Number(1,0)	SMALLINT NOT NULL	Amount of decimal places to take a numeric value out to
21	EP_RATE_MODEL_MAP	Character(1)	VARCHAR2(1) NOT NULL	Mapping used to determine the rating text to display H=Next Highest Rating L=Next Lowest Rating N=Nearest Rating Default Value: N
22	EP_OFFICIAL_SW	Character(1)	VARCHAR2(1) NOT NULL	This Yes/No switch can be set to "Y" by the user to denote that the review is "Official". The setting of this field has no real significance in the application, it is primarily a user-controlled informational field. Y/N Table Edit Default Value: N
23	APPR_RULE_SET	Character(30)	VARCHAR2(30) NOT NULL	Approval Rule Set Prompt Table: EP_APPR_RULE_VW
24	EP_EE_REVIEW_FLG	Character(2)	VARCHAR2(2) NOT NULL	Field used to determine the process flow for a performance review. 01=Approval Before EE Review Held 02=Approval After EE Review Held 03=No Approval, EE Review Held 04=No Approval, No EE Review Held 05=Approval, No EE Review Held Default Value: 01
25	EP_CALC_RATING_SW	Character(1)	VARCHAR2(1) NOT NULL	Yes/No switch used to determine if a performance review calculates ratings. Y/N Table Edit Default Value: Y
26	EP_LANG_CHECK_SW	Character(1)	VARCHAR2(1) NOT NULL	Yes/No switch used to determine if the language checker is used on the manager's performance review. Y/N Table Edit Default Value: N
27	EP_EST_STEP_SW	Character(1)	VARCHAR2(1) NOT NULL	Switch that determines if the establish criteria step is enabled. Y/N Table Edit Default Value: N
28	EP_EST_UPD_EE_SW	Character(1)	VARCHAR2(1) NOT NULL	Switch that determines if an employee can update the baseline document during the establish criteria step. Y/N Table Edit Default Value: N
29	EP_EST_UPD_MGR_SW	Character(1)	VARCHAR2(1) NOT NULL	Switch that determines if a manager can update the baseline document during the establish criteria step. Y/N Table Edit Default Value: N
30	EP_EST_CMP_ROLE	Character(8)	VARCHAR2(8) NOT NULL	Role that determines if an employee or manager can complete the baseline document during the establish criteria step. Prompt Table: EP_ROLE_VW1
31	EP_EST_DUE_DAYS	Number(3,0)	SMALLINT NOT NULL	Amount of days in which the establish criteria step is due.
32	EP_EST_DUE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Type of due date - Before or After the period end date. Used for the establish criteria step. A=After Period End Date B=Before Period End Date
33	EP_NOM_STEP_SW	Character(1)	VARCHAR2(1) NOT NULL	Switch that determines if the nomination process is enabled. Y/N Table Edit Default Value: N
34	EP_NOM_UPD_EE_SW	Character(1)	VARCHAR2(1) NOT NULL	Switch that determines if an employee can update the nominations list during the nominate participants process. Y/N Table Edit Default Value: N
35	EP_NOM_UPD_MGR_SW	Character(1)	VARCHAR2(1) NOT NULL	Switch that determines if a manager can update the nominations list during the nominate participants process. Y/N Table Edit Default Value: N
36	EP_NOM_SUB_ROLE	Character(8)	VARCHAR2(8) NOT NULL	Role that determines if an employee or manager can submit nominations document during the nominate participant process. Prompt Table: EP_ROLE_VW1
37	EP_NOM_TRK_EE_SW	Character(1)	VARCHAR2(1) NOT NULL	Switch that determines if an employee can track the nomination acceptance/denial/cancellation during the nominate participants process. Y/N Table Edit Default Value: N
38	EP_NOM_TRK_MGR_SW	Character(1)	VARCHAR2(1) NOT NULL	Switch that determines if a manager can track the nomination acceptance/denial/cancellation during the nominate participants process. Y/N Table Edit Default Value: N
39	EP_NOM_DUE_DAYS	Number(3,0)	SMALLINT NOT NULL	Amount of days in which the nominate participants process is due.
40	EP_NOM_DUE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Type of due date - Before or After the period end date. Used for the nominate participants process. A=After Period End Date B=Before Period End Date
41	EP_TRK_FDBK_EE_SW	Character(1)	VARCHAR2(1) NOT NULL	Switch that determines if an employee can track participant feedback during the track participant feedback process. Y/N Table Edit Default Value: N
42	EP_TRK_FDBK_MGR_SW	Character(1)	VARCHAR2(1) NOT NULL	Switch that determines if a manager can track participant feedback during the track participant feedback process. Y/N Table Edit Default Value: N
43	EP_TRK_VIEW_EE_SW	Character(1)	VARCHAR2(1) NOT NULL	Switch that determines if an employee can view participant documents during the track participant feedback process. Y/N Table Edit Default Value: N
44	EP_TRK_VIEW_MGR_SW	Character(1)	VARCHAR2(1) NOT NULL	Switch that determines if a manager can view participant documents during the track participant feedback process. Y/N Table Edit Default Value: N
45	EP_VIEW_AVG_EE_SW	Character(1)	VARCHAR2(1) NOT NULL	ePerformance flag Y/N Table Edit Default Value: N
46	EP_VIEW_AVG_MGR_SW	Character(1)	VARCHAR2(1) NOT NULL	ePerformance Flag Y/N Table Edit Default Value: N
47	EP_CANCEL_OUT_SW	Character(1)	VARCHAR2(1) NOT NULL	Switch that determines if outstanding evaluations and nominations are cancelled when the manager evaluation moves past 'in progress' status. Y/N Table Edit Default Value: N
48	PTAFDEFN_ID	Character(30)	VARCHAR2(30) NOT NULL	Definition ID Prompt Table: EP_PTAFAW_PRCS
49	EP_PRE_REVW_RATING	Character(1)	VARCHAR2(1) NOT NULL	Preliminary Review Rating Code (character). Prompt Table: REVW_RATING_TBL
50	EP_PRE_RATING	Number(6,2)	DECIMAL(5,2) NOT NULL	Preliminary Rating (numeric)
51	EP_PRE_POINTS	Number(3,0)	SMALLINT NOT NULL	Preliminary Rating Points
52	EP_RATING	Number(6,2)	DECIMAL(5,2) NOT NULL	Rating
53	RATING_MODEL	Character(4)	VARCHAR2(4) NOT NULL	Rating Model
54	REVIEW_POINTS	Number(3,0)	SMALLINT NOT NULL	Review Points
55	EP_CALC_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Calculation method used - Summary, Average, Review Band A=Average R=Review Band S=Summation
56	REVIEW_RATING	Character(1)	VARCHAR2(1) NOT NULL	Review Rating
57	EP_RTG_OVERRIDE	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether the calculated Rating for this item or section has been manually overridden by the user. Y/N Table Edit Default Value: N
58	EP_EMPL_ACK_IND	Character(4)	VARCHAR2(4) NOT NULL	This field tracks whether an employee has acknowledged that a review has been held. Note that it does not indicate whether the employee agrees with the content of the review. ACKN=Employee Acknowledged NREQ=Not Required OPEN=Open OVRD=Manager Override RFSD=Employee Refused
59	EP_EMPL_ACK_DT	Date(10)	DATE	This field tracks the date that the employee acknowledged that a review has been held.
60	LANG_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code CFR=Canadian French DAN=Danish DUT=Dutch ENG=English ESP=Spanish FRA=French GER=German GRK=Greek INE=International English ITA=Italian JPN=Japanese KOR=Korean POR=Portuguese SVE=Swedish THA=Thai ZHS=Simplified Chinese ZHT=Traditional Chinese
61	EP_MANAGER_ID	Character(11)	VARCHAR2(11) NOT NULL	Manager/Mentor ID.
62	EP_CREATE_DTTM	DateTime(26)	TIMESTAMP	Specifies the date and time a document was created.
63	EP_CREATE_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which created a document.
64	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
65	PTAFORIG_OPRID	Character(30)	VARCHAR2(30) NOT NULL	User ID
66	PTAFREQUESTOR_ID	Character(30)	VARCHAR2(30) NOT NULL	Requestor id