SAD_CRM_TPC_TBL (SQL View)	Index Back
SAD_CRM_TPC_TBL SAD_CRM_TPC_TBL. This is used in the CRM/SA EIP Process.

SAD_CRM_TPC_TBL

(SQL View)

SAD_CRM_TPC_TBL

SAD_CRM_TPC_TBL. This is used in the CRM/SA EIP Process.

SELECT A.RY_MD_ELEM_ID , A.LABEL_TEXT , A.ROW_LASTMANT_DTTM FROM PS_RY_DOC_ELEM_PR A , PS_RY_MDATA_ELEM B , PS_RY_DOC_DB_DEF C , PS_RY_PROF_DB_DEF D WHERE B.RY_MD_ELEM_ID = A.RY_MD_ELEM_ID AND C.RY_MD_ELEM_ID = B.RY_MD_ELEM_ID AND D.RY_MD_ELEM_ID = C.RY_PROF_MD_ELEM_ID AND B.RY_DATA_STATUS = 'A' AND D.IS_PROF_QUESTION = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SAD_CRM_TOPIC_ID Number(18,0) DECIMAL(18) NOT NULL Field used to store the unique identifier of the topic to which the applicant has responded that is being passed from the CRM system.

2 SAD_CRM_TOPIC Character(254) VARCHAR2(254) NOT NULL Field used to store the topic to which the applicant is responding that is being passed from the CRM system.

3 LASTCHANGEDDTTM DateTime(26) TIMESTAMP LASTCHANGEDDTTM

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SAD_CRM_TOPIC_ID	Number(18,0)	DECIMAL(18) NOT NULL	Field used to store the unique identifier of the topic to which the applicant has responded that is being passed from the CRM system.
2	SAD_CRM_TOPIC	Character(254)	VARCHAR2(254) NOT NULL	Field used to store the topic to which the applicant is responding that is being passed from the CRM system.
3	LASTCHANGEDDTTM	DateTime(26)	TIMESTAMP	LASTCHANGEDDTTM