SCC_COMM_CHKTYP (SQL Table)	Index Back
Communications Checklist Type Communications Checklist Type identifies the high level Checklist Types to be included with the Communication Generation batch process for a single Letter Code.

SCC_COMM_CHKTYP

(SQL Table)

Communications Checklist Type

Communications Checklist Type identifies the high level Checklist Types to be included with the Communication Generation batch process for a single Letter Code.

Parent record: SCC_COMM_CHKLST

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

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

4 SCC_CHECKLIST_TYPE Character(3) VARCHAR2(3) NOT NULL Checklist Type.
ADC=Condition List
CML=Communication List
HIR=Hiring
MED=Medical
OTH=Other
PRM=Promise
RQL=Requirements List
SAL=Staff Assignment List
TER=Termination
TRN=Training
XFR=Transfer

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	ADMIN_FUNCTION	Character(4)	VARCHAR2(4) NOT NULL	Administrative Function Prompt Table: ADM_FUNCTN_TBL
4	SCC_CHECKLIST_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Checklist Type. ADC=Condition List CML=Communication List HIR=Hiring MED=Medical OTH=Other PRM=Promise RQL=Requirements List SAL=Staff Assignment List TER=Termination TRN=Training XFR=Transfer