HCTS_SETUP_TBL

#	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_REVIEW_TP_VW
2	HCTS_REVIEW_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Review type Prompt Table: EP_REVIEW_TP_VW
3	HCTS_HIDE_RTBX1	Character(1)	VARCHAR2(1) NOT NULL	Display Rating Box Chart N=No Y=Yes
4	HCTS_HIDE_RTBX2	Character(1)	VARCHAR2(1) NOT NULL	Display Rating Box Chart N=No Y=Yes
5	RATING_MODEL	Character(4)	VARCHAR2(4) NOT NULL	Rating Model Prompt Table: RATING_MDL_VW
6	HCTS_EXP_LICENSES	Character(1)	VARCHAR2(1) NOT NULL	Include Expired Licenses N=No Y=Yes
7	HRCD_PR_PHOTO_FLG	Character(1)	VARCHAR2(1) NOT NULL	This field indicates if a photo will be displayed for the Profile Content of the Company Directory.
8	HCTS_POTENTL_AXIS	Character(1)	VARCHAR2(1) NOT NULL	Potential Rating Axis 1=1 2=2 3=3 4=4 5=5 Default Value: 3
9	HCTS_POTENTL_LABEL	Character(15)	VARCHAR2(15) NOT NULL	Potential Axis Label
10	HCTS_PERF_AXIS	Character(1)	VARCHAR2(1) NOT NULL	Performance Rating Axis 1=1 2=2 3=3 4=4 5=5 Default Value: 3
11	HCTS_PERF_LABEL	Character(15)	VARCHAR2(15) NOT NULL	Performance Axis Label
12	HCTS_LOSSRSK_LABEL	Character(15)	VARCHAR2(15) NOT NULL	Risk Axis Label
13	HCTS_IMPACT_LABEL	Character(15)	VARCHAR2(15) NOT NULL	Impact Axis Label
14	HCTS_IM_DISPLAY	Character(1)	VARCHAR2(1) NOT NULL	Display IM Icon N=No Y=Yes
15	HCTS_COMP_RANGE	Number(4,0)	SMALLINT NOT NULL	Competency Range
16	HCTS_PERF_RANGE	Number(4,0)	SMALLINT NOT NULL	Performance Range
17	HCTS_PROJ_RANGE	Number(4,0)	SMALLINT NOT NULL	Project Range
18	HCTS_SP_DRAFT	Character(1)	VARCHAR2(1) NOT NULL	Draft N=No Y=Yes
19	HCTS_SP_OFFICIAL	Character(1)	VARCHAR2(1) NOT NULL	Official N=No Y=Yes