HRS_SCRJPM_TAO

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	HRS_JO_SCR_SUMM_ID	Number(15,0)	DECIMAL(15) NOT NULL	JO Screening Summary ID Prompt Table: HRS_JO_SCR_SM_I
3	HRS_JO_SCR_SEQ	Number(3,0)	SMALLINT NOT NULL	Job opening screening sequence Prompt Table: HRS_JO_SCR_LV_I
4	JPM_PROFILE_ID	Character(12)	VARCHAR2(12) NOT NULL	The id, autoassigned or user assigned of the profile. This id is used to group items and other related material together into one coherent profile.
5	JPM_CAT_TYPE	Character(12)	VARCHAR2(12) NOT NULL	The name of the type of items that will be used in a Catalog and or in a Profile.
6	JPM_CAT_ITEM_ID	Character(12)	VARCHAR2(12) NOT NULL	Catalog Item Id. Identifies a unique catalog item defintion within a catalog type.
7	JPM_CAT_ITEM_QUAL	Character(12)	VARCHAR2(12) NOT NULL	Low Order Item key for Catalog Items when appearing in a Profile. For most Catalog Types, this will be blank - but is available if an Item needs to have multiple instances for a given Effdt in a Profile. Example: for CatalogType = Compentency, there can be multiple instances for a particular Competency, each representing a different evaluation source (Self-Eval, Mgr Eval, Approved/Official, Learning, Recruiting).
8	JPM_CAT_ITEM_QUAL2	Character(12)	VARCHAR2(12) NOT NULL	Low Order Item key for Catalog Items when appearing in a Profile. For most Catalog Types, this will be blank - but is available if an Item needs to have multiple instances for a given Effdt in a Profile. Example: for CatalogType = Compentency, there can be multiple instances for a particular Competency, each representing a different evaluation source (Self-Eval, Mgr Eval, Approved/Official, Learning, Recruiting).
9	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
10	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
11	POINTS	Signed Number(5,0)	DECIMAL(4) NOT NULL	Points
12	HRS_JO_SCR_REQD	Character(1)	VARCHAR2(1) NOT NULL	Job Opening Screening Requirement Required Y/N Table Edit Default Value: N
13	HRS_JO_SCR_AUGMENT	Character(1)	VARCHAR2(1) NOT NULL	Augmentation factor Y/N Table Edit Default Value: N
14	HRS_JO_SCR_SELECT	Character(1)	VARCHAR2(1) NOT NULL	Selective factor Y/N Table Edit Default Value: N