SCC_STN_LTR_TBL (SQL Table)	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_TBL

(SQL Table)

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.

Related Language Record: SCC_STNDLTR_LAN

Parent Record Of SCC_CGXPRPT2_VW SCC_CG_XMLP_RPT SCC_CG_XPRPT_VW SCC_COMM_CHKLST

# 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

5 ADMIN_FUNCTION Character(4) VARCHAR2(4) NOT NULL Administrative Function
Prompt Table: ADM_FUNCTN_TBL

6 SQC_NAME Character(8) VARCHAR2(8) NOT NULL Name of SQC for Unique Data

7 ENCL_TYPE Character(1) VARCHAR2(1) NOT NULL Enclosure Type
H=Hardcopy
S=Softcopy
Default Value: S

8 LTR_PRINT_DATA_OPT Character(4) VARCHAR2(4) NOT NULL Letter Printed Data
ALL=All
NMAD=Name/Address Only
NONE=None
Default Value: NMAD

9 ALLOW_JOINT Character(1) VARCHAR2(1) NOT NULL Joint Communications Allowed
Y/N Table Edit
Default Value: N

10 INCLUDE_ENCL Character(1) VARCHAR2(1) NOT NULL Include Enclosures
Y/N Table Edit
Default Value: N

11 ADMIN_FCN_PEOPLE Character(1) VARCHAR2(1) NOT NULL Admin Function - People
Y/N Table Edit

12 ADMIN_FCN_ORG Character(1) VARCHAR2(1) NOT NULL Admin Function - Organizations
Y/N Table Edit

13 SCC_CG_PARMS Character(1) VARCHAR2(1) NOT NULL Define Communication Generation Parameters
Y/N Table Edit
Default Value: N

#	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
5	ADMIN_FUNCTION	Character(4)	VARCHAR2(4) NOT NULL	Administrative Function Prompt Table: ADM_FUNCTN_TBL
6	SQC_NAME	Character(8)	VARCHAR2(8) NOT NULL	Name of SQC for Unique Data
7	ENCL_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Enclosure Type H=Hardcopy S=Softcopy Default Value: S
8	LTR_PRINT_DATA_OPT	Character(4)	VARCHAR2(4) NOT NULL	Letter Printed Data ALL=All NMAD=Name/Address Only NONE=None Default Value: NMAD
9	ALLOW_JOINT	Character(1)	VARCHAR2(1) NOT NULL	Joint Communications Allowed Y/N Table Edit Default Value: N
10	INCLUDE_ENCL	Character(1)	VARCHAR2(1) NOT NULL	Include Enclosures Y/N Table Edit Default Value: N
11	ADMIN_FCN_PEOPLE	Character(1)	VARCHAR2(1) NOT NULL	Admin Function - People Y/N Table Edit
12	ADMIN_FCN_ORG	Character(1)	VARCHAR2(1) NOT NULL	Admin Function - Organizations Y/N Table Edit
13	SCC_CG_PARMS	Character(1)	VARCHAR2(1) NOT NULL	Define Communication Generation Parameters Y/N Table Edit Default Value: N