SAD_CRM_TPC_TBL (SQL Table)	Index Back
Topic Table SAD_CRM_TPC_TBL stores the Topic IDs and Topics to which the applicant has responded in the CRM system.

SAD_CRM_TPC_TBL

(SQL Table)

Topic Table

SAD_CRM_TPC_TBL stores the Topic IDs and Topics to which the applicant has responded in the CRM system.

# 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 LASTCHANGEDTTM DateTime(26) TIMESTAMP NOT NULL Used to identify the last time the object was changed

#	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	LASTCHANGEDTTM	DateTime(26)	TIMESTAMP NOT NULL	Used to identify the last time the object was changed