SAD_CRM_ADM_TXT

(SQL Table)
Index Back

CRM Long Text Responses

This record holds the Lobg text responses associated with an EMPLID that was transmitted from the CRM system.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSONAL_DATA

2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INST_CAR_SCTY

3 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
BAC=Bachelor (NLD)
BBL=Vocational Coaching (NLD)
BOL=Vocational Training (NLD)
BUSN=Graduate Business
CNED=Continuing Education
CRED=Semester Credit
EDU=Education (NLD)
EXED=Extended Education
GRAD=Graduate
LAW=Law
MEDS=Medical School
NONA=Non Award
PGRD=Postgraduate
RSCH=Research
TECH=Technical
UENG=Undergraduate Engineering
UGRD=Undergraduate
VAVO=Advanced General Educ. (NLD)
VETM=Veterinary Medicine

Prompt Table: STDNT_CAREER

4 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.

Prompt Table: SAD_CRM_TPC_TBL

5 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
6 SAD_CRM_LONG_TEXT Long Character CLOB SAD_CRM_LONG_TEXT is used to store the Long Text response an applicant may have given in the CRM system