CS_CHKLST_TBL (SQL Table)	Index Back
CS Checklist Codes Use CS_CHKLST_TBL and CS_CHKLST_ITEM to create and maintain checklists used by your institution. CS_CHKLST_TBL contains the code assigned to the checklist and a description of the checklist. It also contains the Administrative Function to which it is related. CS_CHKLST_ITEM contains the specific items on the checklist. Checklists may be used to keep track of documents people need to submit to fulfill a requirement, to generate a series of communication items, to assign admission conditions, to create staff assignments, etc.

CS_CHKLST_TBL

(SQL Table)

CS Checklist Codes

Use CS_CHKLST_TBL and CS_CHKLST_ITEM to create and maintain checklists used by your institution. CS_CHKLST_TBL contains the code assigned to the checklist and a description of the checklist. It also contains the Administrative Function to which it is related. CS_CHKLST_ITEM contains the specific items on the checklist. Checklists may be used to keep track of documents people need to submit to fulfill a requirement, to generate a series of communication items, to assign admission conditions, to create staff assignments, etc.

Related Language Record: CS_CHKLST_LANG

Parent Record Of CS_CHKLST_ITEM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTION_TBL

2 CHECKLIST_CD Character(6) VARCHAR2(6) NOT NULL Checklist Code

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

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

6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
Default Value: CS_CHKLST_TBL.DESCR

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

8 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

9 TRACKING_GROUP Character(6) VARCHAR2(6) NOT NULL Tracking Group
Prompt Table: TRACK_GRP_VW

10 DEFAULT_DUE_DT Date(10) DATE Default Due Date

11 DUE_DAYS Number(3,0) SMALLINT NOT NULL Due Days

12 COMM_KEY Character(8) VARCHAR2(8) NOT NULL Communication Speed Key
Prompt Table: COMM_SPDKEY_TBL

13 SCC_TODO_SS_DISP Character(1) VARCHAR2(1) NOT NULL Field to control the display of Checklist code's in Self Service
Y/N Table Edit
Default Value: Y

14 SCC_TODO_ANY_TERM Character(1) VARCHAR2(1) NOT NULL Allow Any Term
Y/N Table Edit
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL
2	CHECKLIST_CD	Character(6)	VARCHAR2(6) NOT NULL	Checklist Code
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description Default Value: CS_CHKLST_TBL.DESCR
7	ADMIN_FUNCTION	Character(4)	VARCHAR2(4) NOT NULL	Administrative Function Prompt Table: ADM_FUNCTN_TBL
8	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
9	TRACKING_GROUP	Character(6)	VARCHAR2(6) NOT NULL	Tracking Group Prompt Table: TRACK_GRP_VW
10	DEFAULT_DUE_DT	Date(10)	DATE	Default Due Date
11	DUE_DAYS	Number(3,0)	SMALLINT NOT NULL	Due Days
12	COMM_KEY	Character(8)	VARCHAR2(8) NOT NULL	Communication Speed Key Prompt Table: COMM_SPDKEY_TBL
13	SCC_TODO_SS_DISP	Character(1)	VARCHAR2(1) NOT NULL	Field to control the display of Checklist code's in Self Service Y/N Table Edit Default Value: Y
14	SCC_TODO_ANY_TERM	Character(1)	VARCHAR2(1) NOT NULL	Allow Any Term Y/N Table Edit Default Value: N