EP_APPR_PNDG

#	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 Record
4	ACTION_DT_SS	Date(10)	DATE	Termination Date
5	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
6	PERIOD_BEGIN_DT	Date(10)	DATE NOT NULL	Period Begin Date
7	PERIOD_END_DT	Date(10)	DATE NOT NULL	Period End Date
8	EP_REVIEW_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Review type Prompt Table: EP_REVW_TYP_VW
9	EP_TEMPLATE_ID	Character(8)	VARCHAR2(8) NOT NULL	Template unique identifier Prompt Table: EP_TMPL_DEFN
10	EP_TMPL_EFFDT	Date(10)	DATE NOT NULL	the effdt of the Template
11	CREATION_DT	Date(10)	DATE NOT NULL	Creation Date Default Value: %Date
12	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
13	EP_EST_DUE_DATE	Date(10)	DATE	Date the establish criteria step is due to be completed.
14	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
15	EP_NOM_DUE_DATE	Date(10)	DATE	Date the nominate participants step is due to be completed.
16	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
17	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
18	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 Default Value: IP
19	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
20	EP_REVIEW_ID	Character(8)	VARCHAR2(8) NOT NULL	Review ID Prompt Table: EP_REV_DEF_VW
21	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
22	EP_DEC_PLACES	Number(1,0)	SMALLINT NOT NULL	Amount of decimal places to take a numeric value out to
23	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
24	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
25	APPR_RULE_SET	Character(30)	VARCHAR2(30) NOT NULL	Approval Rule Set Prompt Table: EP_APPR_RULE_VW
26	EP_EE_REVIEW_FLG	Character(2)	VARCHAR2(2) NOT NULL	Field used to determine the process flow for a performance review. 01=Apvl Before Review-5 Steps 02=Apvl After Review-4 Steps 03=No Apvl with Review-4 Steps 04=No Apvl No Review 05=Apvl No Review 06=No Apvl with Review-2 Steps 07=Apvl Before Review-3 Steps 08=Apvl After Review-3 Steps Default Value: 01
27	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
28	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
29	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
30	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
31	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
32	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
33	EP_EST_DUE_DAYS	Number(3,0)	SMALLINT NOT NULL	Amount of days in which the establish criteria step is due.
34	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
35	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
36	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
37	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
38	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
39	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
40	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
41	EP_NOM_DUE_DAYS	Number(3,0)	SMALLINT NOT NULL	Amount of days in which the nominate participants process is due.
42	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
43	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
44	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
45	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
46	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
47	EP_VIEW_AVG_EE_SW	Character(1)	VARCHAR2(1) NOT NULL	ePerformance flag Y/N Table Edit Default Value: N
48	EP_VIEW_AVG_MGR_SW	Character(1)	VARCHAR2(1) NOT NULL	ePerformance Flag Y/N Table Edit Default Value: N
49	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
50	EOAWDEFN_ID	Character(30)	VARCHAR2(30) NOT NULL	Approval Framework Definition ID Prompt Table: EP_PTAFAW_PRCS
51	EP_ATTACH_SW	Character(1)	VARCHAR2(1) NOT NULL	Attachment Switch Y/N Table Edit Default Value: N
52	EP_TP_STEP_SW	Character(1)	VARCHAR2(1) NOT NULL	Template header switch on General Tab specifying whether or not Track Progresss step is available Y/N Table Edit Default Value: N
53	EP_DUE_DATE_MTHOD	Character(1)	VARCHAR2(1) NOT NULL	Due Date Method C=Performance Calendar T=Template Setup Default Value: T
54	EP_CALENDAR_ID	Character(8)	VARCHAR2(8) NOT NULL	Calendar id Prompt Table: EP_CALENDAR
55	EP_PERIOD_ID	Character(8)	VARCHAR2(8) NOT NULL	This field stores the Period specified for a Calendar ID. Prompt Table: EP_CAL_PERIOD
56	EP_TP_UPD_BY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Template switch on Process Tab specifying which roles can update the Track Progress appraisals B=Manager and Employee M=Manager Default Value: M
57	EP_TP_EE_CMNTS_SW	Character(1)	VARCHAR2(1) NOT NULL	Template switch on Process Tab specifying whether the Employee role has comments enabled. Y/N Table Edit Default Value: N
58	EP_TP_NBR_CHECKPTS	Number(2,0)	SMALLINT NOT NULL	The Number of Checkpoints defined for the Track Progress step.
59	EP_TP_COMP_BY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Template switch on Process Tab specifying which role completes the Track Progress checkpoints B=Manager and Employee E=Employee M=Manager Default Value: M
60	EP_TP_DUE_DAYS	Number(4,0)	SMALLINT NOT NULL	Track Progress completion date in days
61	EP_TP_DUE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Track Progress completion date type Before or After the period end date. A=After Period End Date B=Before Period End Date Default Value: B
62	EP_CPY_RTGS_SW	Character(1)	VARCHAR2(1) NOT NULL	Copy Track Progress Ratings to Evaluations? Y/N Table Edit Default Value: N
63	EP_CPY_CMNTS_SW	Character(1)	VARCHAR2(1) NOT NULL	Copy Track Progress Comments to Evaluations? Y/N Table Edit Default Value: N
64	EP_SAVE_EC_SW	Character(1)	VARCHAR2(1) NOT NULL	Save Establish Criteria document when approved? Y/N Table Edit Default Value: Y
65	EP_SAVE_TP_SW	Character(1)	VARCHAR2(1) NOT NULL	Save the Completed Track Progress document? Y/N Table Edit Default Value: Y
66	EP_SAVE_CHKPTS_SW	Character(1)	VARCHAR2(1) NOT NULL	Template process tab, whether or not checkpoint docs are stored Y/N Table Edit Default Value: Y
67	EP_TITLE_FORMAT_SW	Character(1)	VARCHAR2(1) NOT NULL	Field specifying whether or not to concatenate the Sub-Step onto the Step in the Page Title of the document Y/N Table Edit Default Value: Y
68	EP_EE_ATTACH_SW	Character(1)	VARCHAR2(1) NOT NULL	Attachment Switch on the Template to allow employees to add/remove attachments in the self-evaluation document Y/N Table Edit Default Value: N
69	EP_EE_VIEW_NOM_SW	Character(1)	VARCHAR2(1) NOT NULL	Switch on the Template to allow employees to view nominees before nomination is submitted Y/N Table Edit Default Value: Y
70	EP_EE_DEL_NOM_SW	Character(1)	VARCHAR2(1) NOT NULL	Switch on the Template to allow employees to view/delete nominees before nomination is submitted Y/N Table Edit Default Value: Y
71	EP_PARTIC_EARLY_SW	Character(1)	VARCHAR2(1) NOT NULL	Allow Participant Evaluation at any step during the appraisal cycle. Y/N Table Edit Default Value: N
72	EP_MIN_CHAR_CNT	Number(3,0)	SMALLINT NOT NULL	Count of minimum characters required in comments fields. Default Value: 0
73	EP_NOM_SUB_BOTH_FL	Character(1)	VARCHAR2(1) NOT NULL	Use in fluid documents only: Used to allow both manager and employee roles to submit nominations during the nominate participant process. Y/N Table Edit Default Value: N
74	EP_DC_ATTACH	Character(1)	VARCHAR2(1) NOT NULL	Define Criteria Attachment B=Manager and Employee E=Employee M=Manager
75	EP_CP_ATTACH	Character(1)	VARCHAR2(1) NOT NULL	Checkpoint Attachment B=Manager and Employee E=Employee M=Manager
76	EP_FC_ATTACH	Character(1)	VARCHAR2(1) NOT NULL	Finalize Criteria Attachment B=Manager and Employee E=Employee M=Manager
77	EP_MGR_RECOG_SW	Character(1)	VARCHAR2(1) NOT NULL	Allow Manager to View Recognitions Y/N Table Edit Default Value: N
78	EP_EE_RECOG_SW	Character(1)	VARCHAR2(1) NOT NULL	Allow Manager to View Recognitions Y/N Table Edit Default Value: N
79	EP_VIEW_INSTR_FL	Character(1)	VARCHAR2(1) NOT NULL	View Instructions D=Display on Document Page M=Display in Modal Window Default Value: M
80	EP_PRE_REVW_RATING	Character(1)	VARCHAR2(1) NOT NULL	Preliminary Review Rating Code (character). Prompt Table: REVW_RATING_TBL
81	EP_PRE_RATING	Number(6,2)	DECIMAL(5,2) NOT NULL	Preliminary Rating (numeric)
82	EP_PRE_POINTS	Number(3,0)	SMALLINT NOT NULL	Preliminary Rating Points
83	EP_RATING	Number(6,2)	DECIMAL(5,2) NOT NULL	Rating
84	RATING_MODEL	Character(4)	VARCHAR2(4) NOT NULL	Rating Model
85	REVIEW_POINTS	Number(3,0)	SMALLINT NOT NULL	Review Points
86	EP_CALC_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Calculation method used - Summary, Average, Review Band A=Average R=Review Band S=Summation
87	REVIEW_RATING	Character(1)	VARCHAR2(1) NOT NULL	Review Rating
88	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
89	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
90	EP_EMPL_ACK_DT	Date(10)	DATE	This field tracks the date that the employee acknowledged that a review has been held.
91	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
92	EP_MANAGER_ID	Character(11)	VARCHAR2(11) NOT NULL	Manager/Mentor ID.
93	EP_CREATE_DTTM	DateTime(26)	TIMESTAMP	Specifies the date and time a document was created.
94	EP_CREATE_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which created a document.
95	EOAWSTEP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Step Instance Status A=Approved B=Pushed back C=Auto Approved D=Denied E=Administrator denied F=Deleted G=Bypassed H=On Hold I=No Action Taken K=Skipped L=Terminated M=Administrator approved N=Not Active P=Pending R=No longer in role T=Terminated U=Auto approved X=Deleted Z=Pending Denial
96	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
97	EOAWORIG_OPRID	Character(30)	VARCHAR2(30) NOT NULL	User ID
98	EOAWSTART_DT	Date(10)	DATE	Start Date
99	EOAWTHREAD_ID	Number(15,0)	DECIMAL(15) NOT NULL	Approval Framework Thread ID