EP_TMPL_ITEM

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EP_REVIEW_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Review type Prompt Table: EP_REVW_TYP_VW
2	EP_TEMPLATE_ID	Character(8)	VARCHAR2(8) NOT NULL	Template unique identifier
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: EP_TMPL_SECTION.EFFDT
4	EP_SECTION_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Section type Prompt Table: EP_SECTION_DEFN
5	EP_ITEM_ID	Character(12)	VARCHAR2(12) NOT NULL	Item unique identifier Prompt Table: %EDITTABLE
6	EP_ITEM_SEQ	Number(2,0)	SMALLINT NOT NULL	Item sequence number Default Value: 1
7	EP_TITLE	Character(60)	VARCHAR2(60) NOT NULL	Title of an item
8	RATING_MODEL	Character(4)	VARCHAR2(4) NOT NULL	Rating Model Prompt Table: RATING_MDL_TBL
9	EP_MIN_WEIGHT	Number(3,0)	SMALLINT NOT NULL	Minumum weight used (percentage)
10	EP_WEIGHT	Number(3,0)	SMALLINT NOT NULL	Weight factor
11	EP_ITEM_DUE_DT	Date(10)	DATE	Date that an item is due.
12	EP_ITEM_REMIND_DT	Date(10)	DATE	Date to remind an item is due.
13	EP_ITEM_MANDTRY_SW	Character(1)	VARCHAR2(1) NOT NULL	Yes/No switch used to determine if the mandatory field is available Y/N Table Edit Default Value: N
14	EP_ITEM_CRIT_SW	Character(1)	VARCHAR2(1) NOT NULL	Yes/No switch used to determine if the critical field is available Y/N Table Edit Default Value: N
15	EP_ITEM_LINK	Character(12)	VARCHAR2(12) NOT NULL	Field an item is linked to Prompt Table: EP_TMPL_ITEM
16	EP_ITEM_OWNER_IND	Character(1)	VARCHAR2(1) NOT NULL	Translate field used to indicate the owner of a performance review item. E=Employee M=Manager
17	EP_TARGET_RATING	Character(1)	VARCHAR2(1) NOT NULL	Target Rating Field Prompt Table: REVW_RATING_TBL
18	EP_ROW_ADDED_SRC	Character(1)	VARCHAR2(1) NOT NULL	Added By Source C=Cascade P=Profile R=HR Admin (Profile) T=HR Admin (Template) U=User
19	EP_ROW_ADDED_ID	Character(12)	VARCHAR2(12) NOT NULL	Added By ID
20	EP_DESCR254	Long Character	CLOB	1325 character description field used in ePerformance
21	EP_MEASURE	Long Character	CLOB	1325 Character Item measurement description
22	EP_SUB_LEVEL	Character(1)	VARCHAR2(1) NOT NULL	Sub-Competency level Prompt Table: JPM_EP_SUBLV_I
23	EPO_ITEM_ALIGN	Number(8,0)	INTEGER NOT NULL	Used in ePerformance to specify the Objectives Item that Document Items are Aligned to. Prompt Table: EPO_NO_ITEM_VW
24	EP_STRETCH_SW	Character(1)	VARCHAR2(1) NOT NULL	Y/N switch for ePerformance Section Stretch Goal Y/N Table Edit Default Value: N
25	EP_PRIVATE_SW	Character(1)	VARCHAR2(1) NOT NULL	Y/N switch for ePerformance Section. Private, hide from Employees. Y/N Table Edit Default Value: N
26	EP_EE_MEASURE	Long Character	CLOB	An additional Measurement field for the ePerformance Section Definition that is not used in the Content Catalog.
27	EP_ITEM_START_DT	Date(10)	DATE	used for ePerformance Section Definition, Item Start Date
28	EP_ITEM_END_DT	Date(10)	DATE	used for ePerformance Section Definition, Item End Date
29	EPO_PAGE_ID	Number(8,0)	INTEGER NOT NULL	Objectives Management: Objective Page ID
30	EPO_SECTION_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Objectives Section type
31	EPO_OBJ_ITEM_ID	Number(8,0)	INTEGER NOT NULL	Objectives Management: Objective Item ID. Used as a key to hold unique values as Item ID is not a key in Objective Management. It will uniquely define an item on ePerformance document when cascaded or copied over.
32	EPO_SUP_OBJITEM_ID	Number(8,0)	INTEGER NOT NULL	Objectives Supporting Item
33	EPO_OBJ_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Objective Status A=Active Item I=Inactive Item
34	EPO_ITEM_TITLE	Character(60)	VARCHAR2(60) NOT NULL	Title of an Objective item
35	EP_ITEM_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Objectives field to keep track whether tan item was copied, aligned or cascaded A=Align Objective B=Copy Objective C=Copy Performance Document D=Cascade Item N=Non Display Item P=Performance Item
36	EPO_LAST_MOD_DTTM	DateTime(26)	TIMESTAMP	Datetime stamp of when an Item on an Objective Page was last modified