HCSC_CLK_EVTDFN (SQL Table)	Index Back
Comp Lock Event Definition Component Lock Event Definition

HCSC_CLK_EVTDFN

(SQL Table)

Comp Lock Event Definition

Component Lock Event Definition

Related Language Record: HCSC_CLK_EVTDLN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HCSC_CLK_EVLCKTYPE Character(1) VARCHAR2(1) NOT NULL Lockdown type (Process, General )
G=General
P=Process

2 HCSC_CLK_EVENTID Character(12) VARCHAR2(12) NOT NULL Lockdown Event Definition ID

3 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

4 HCSC_CLK_EVNT_STAT Character(1) VARCHAR2(1) NOT NULL Indicates Event mapping status. It shows any of the 4 values - Enabled/Not Enabled/Failed /New
A=Active
I=Inactive

5 HCSC_CLK_LOCKNOW Character(1) VARCHAR2(1) NOT NULL Indicator for Component Eligible for Process based Lockdown
D=Use Process Phase
G=Use Schedule
L=Lockdown Now
U=Unlock Now

6 HCSC_CLK_LCKPERIOD Character(2) VARCHAR2(2) NOT NULL Indicator for Component Eligible for Process based Lockdown
NA=Not Applicable
PC=Lock Prior and Current Period
PP=Lock Prior Period
Default Value: NA

7 HCSC_CLK_THRUALPHS Character(1) VARCHAR2(1) NOT NULL Indicator for Component Eligible for Process based Lockdown
Y/N Table Edit
Default Value: N

8 HCSC_CLK_OFCYNOLCK Character(1) VARCHAR2(1) NOT NULL Indicator for Component Eligible for Process based Lockdown
Y/N Table Edit
Default Value: N

9 HCSC_CLK_OFCYALPHS Character(1) VARCHAR2(1) NOT NULL Indicator for Component Eligible for Process based Lockdown
Y/N Table Edit
Default Value: N

10 HCSC_CLK_LKSCHDOPT Character(3) VARCHAR2(3) NOT NULL Lock Schedule Options - Enabled, Disable Temporarily.
DSB=Disable Schedule
ENB=Enable Schedule
Default Value: ENB

11 HCSC_CLK_MSG_TYPE Character(1) VARCHAR2(1) NOT NULL Used in Lockdown Event definition
M=Message Catalog
T=Text

12 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
Prompt Table: PSMSGSETDEFN

13 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
Prompt Table: HCSC_CLK_MSG_VW

14 MESSAGE_TEXT Character(100) VARCHAR2(100) NOT NULL Message Text This field refers to the Text for a particular Message Number in the Message Catalog.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HCSC_CLK_EVLCKTYPE	Character(1)	VARCHAR2(1) NOT NULL	Lockdown type (Process, General ) G=General P=Process
2	HCSC_CLK_EVENTID	Character(12)	VARCHAR2(12) NOT NULL	Lockdown Event Definition ID
3	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
4	HCSC_CLK_EVNT_STAT	Character(1)	VARCHAR2(1) NOT NULL	Indicates Event mapping status. It shows any of the 4 values - Enabled/Not Enabled/Failed /New A=Active I=Inactive
5	HCSC_CLK_LOCKNOW	Character(1)	VARCHAR2(1) NOT NULL	Indicator for Component Eligible for Process based Lockdown D=Use Process Phase G=Use Schedule L=Lockdown Now U=Unlock Now
6	HCSC_CLK_LCKPERIOD	Character(2)	VARCHAR2(2) NOT NULL	Indicator for Component Eligible for Process based Lockdown NA=Not Applicable PC=Lock Prior and Current Period PP=Lock Prior Period Default Value: NA
7	HCSC_CLK_THRUALPHS	Character(1)	VARCHAR2(1) NOT NULL	Indicator for Component Eligible for Process based Lockdown Y/N Table Edit Default Value: N
8	HCSC_CLK_OFCYNOLCK	Character(1)	VARCHAR2(1) NOT NULL	Indicator for Component Eligible for Process based Lockdown Y/N Table Edit Default Value: N
9	HCSC_CLK_OFCYALPHS	Character(1)	VARCHAR2(1) NOT NULL	Indicator for Component Eligible for Process based Lockdown Y/N Table Edit Default Value: N
10	HCSC_CLK_LKSCHDOPT	Character(3)	VARCHAR2(3) NOT NULL	Lock Schedule Options - Enabled, Disable Temporarily. DSB=Disable Schedule ENB=Enable Schedule Default Value: ENB
11	HCSC_CLK_MSG_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Used in Lockdown Event definition M=Message Catalog T=Text
12	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog. Prompt Table: PSMSGSETDEFN
13	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog. Prompt Table: HCSC_CLK_MSG_VW
14	MESSAGE_TEXT	Character(100)	VARCHAR2(100) NOT NULL	Message Text This field refers to the Text for a particular Message Number in the Message Catalog.