SCC_STN_LTR_PT (SQL View)	Index Back
Standard Letter Codes SCC_STN_LTR_TBL houses the codes for standard letters. Standard letters are sent to applicants and students in response to certain activities. For example, you could send a letter to an applicant to invite them to an interview, or you could send a letter to a student to notify them of enrollment in a course.

SCC_STN_LTR_PT

(SQL View)

Standard Letter Codes

SCC_STN_LTR_TBL houses the codes for standard letters. Standard letters are sent to applicants and students in response to certain activities. For example, you could send a letter to an applicant to invite them to an interview, or you could send a letter to a student to notify them of enrollment in a course.

SELECT SCC_LETTER_CD , SCC_SET_LETTER_CD , DESCR , DESCRSHORT FROM PS_SCC_STN_LTR_TBL

Related Language Record: SCC_STNDLTR_LAN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCC_LETTER_CD Character(3) VARCHAR2(3) NOT NULL Letter Code

2 SCC_SET_LETTER_CD Character(4) VARCHAR2(4) NOT NULL Set Letter Code
ADML=Admit Letters
APP=Recruitment Letters
AVAK=CR Acknowledgements
AVIN=CR Initiatives
AVMS=CR Membership
CAT=School Catalog
CBR=COBRA Letters
CUST=Customers Letters
GADM=Graduate Admissions
HIPA=HIPAA Certificate
INQU=Inquiry Response Letters
LAW=Law Recruitment
MED=Medical School Recruitment
MLR=Manage Labor Relation
PERC=Post Enrollment Requisite Chk
REV=Employee Review Letters
TRN=Training Letters
UADM=Undergraduate Admissions

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
Default Value: SCC_STN_LTR_TBL.DESCR

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCC_LETTER_CD	Character(3)	VARCHAR2(3) NOT NULL	Letter Code
2	SCC_SET_LETTER_CD	Character(4)	VARCHAR2(4) NOT NULL	Set Letter Code ADML=Admit Letters APP=Recruitment Letters AVAK=CR Acknowledgements AVIN=CR Initiatives AVMS=CR Membership CAT=School Catalog CBR=COBRA Letters CUST=Customers Letters GADM=Graduate Admissions HIPA=HIPAA Certificate INQU=Inquiry Response Letters LAW=Law Recruitment MED=Medical School Recruitment MLR=Manage Labor Relation PERC=Post Enrollment Requisite Chk REV=Employee Review Letters TRN=Training Letters UADM=Undergraduate Admissions
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description Default Value: SCC_STN_LTR_TBL.DESCR