FT_CI_RTNG_VW

(SQL View)
 Index Back

Cat Item Rating Descriptions

Catalog Item Rating Descriptions. This table permits alternate rating descriptions for each rating for each catalog item.

SELECT A.JPM_CAT_TYPE , A.JPM_CAT_ITEM_ID , A.REVIEW_RATING , A.RATING_MODEL , A.FT_TPCI_RD_GUID , A.FT_BUS_GROUP_GUID , A.FT_TPCT_GUID , A.FT_TPCI_GUID , A.FT_TPRL_GUID , B.DESCRLONG , A.FT_OBJ_VER_NUM , A.FT_CREATED_BY , A.FT_CREATION_DATE , A.FT_LAST_UPD_DATE , A.FT_LAST_UPDATED_BY , A.FT_LAST_UPD_LOGIN , A.FT_PROC_MARKER , A.FT_ERROR_FLAG , A.FT_BYPASS_FLAG , A.FT_ALTERNATE_REC , A.FT_ALTERNATE_KEY , A.FT_SYSTEM_DATA_FLG FROM PS_FT_TPCI_RTNG A , PS_CM_RATING_DESCR B WHERE A.JPM_CAT_TYPE = 'COMPETENCY' AND A.JPM_CAT_ITEM_ID = B.COMPETENCY AND A.REVIEW_RATING = B.REVIEW_RATING

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 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.

Prompt Table: JPM_CAT_TYPES

2 JPM_CAT_ITEM_ID Character(12) VARCHAR2(12) NOT NULL Catalog Item Id. Identifies a unique catalog item defintion within a catalog type.

Prompt Table: JPM_CAT_ITEMS

3 REVIEW_RATING Character(1) VARCHAR2(1) NOT NULL Review Rating

Prompt Table: JPM_RATING_VW

4 RATING_MODEL Character(4) VARCHAR2(4) NOT NULL Rating Model
5 FT_TPCI_RD_GUID Character(36) VARCHAR2(36) NOT NULL TalentProfileContentItem GUID
6 FT_BUS_GROUP_GUID Character(36) VARCHAR2(36) NOT NULL Business Group ID
7 FT_TPCT_GUID Character(36) VARCHAR2(36) NOT NULL TalentProfileContentType GUID
8 FT_TPCI_GUID Character(36) VARCHAR2(36) NOT NULL TalentProfileContentItem GUID
9 FT_TPRL_GUID Character(36) VARCHAR2(36) NOT NULL Rating Level GUID
10 FT_DESCRLONG Long Character(1325) VARCHAR2(1325) Long Description
11 FT_OBJ_VER_NUM Number(9,0) DECIMAL(9) NOT NULL Object Version Number
12 FT_CREATED_BY Character(64) VARCHAR2(64) NOT NULL Created By
13 FT_CREATION_DATE Date(10) DATE Creation Date
14 FT_LAST_UPD_DATE Date(10) DATE Last Updated Date
15 FT_LAST_UPDATED_BY Character(64) VARCHAR2(64) NOT NULL Last Updated By
16 FT_LAST_UPD_LOGIN Character(32) VARCHAR2(32) NOT NULL Last Updated Login
17 FT_PROC_MARKER Character(36) VARCHAR2(36) NOT NULL Process marker field
18 FT_ERROR_FLAG Character(1) VARCHAR2(1) NOT NULL Error Flag
N=No
Y=Yes

Default Value: N

19 FT_BYPASS_FLAG Character(1) VARCHAR2(1) NOT NULL Bypass Flag

Default Value: N

20 FT_ALTERNATE_REC Character(50) VARCHAR2(50) NOT NULL Source Record
21 FT_ALTERNATE_KEY Character(254) VARCHAR2(254) NOT NULL Alternate Key
22 FT_SYSTEM_DATA_FLG Character(1) VARCHAR2(1) NOT NULL This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.