| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 HCSC_CAL_EVENT_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Transaction or Event Type ID
|
| 2 |
HCSC_CAL_EVT_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Transaction or Event Name
|
| 3 |
HCSC_CAL_ORD_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence or Order number
|
| 4 |
IMAGE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
The name of images used in Personalizations explanations.
Prompt Table:
PTPPB_IMGCAT_VW
|
| 5 |
HCSC_CAL_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction or Event Status
A=Active
I=Inactive
Default Value: A
|
| 6 |
HCSC_CAL_OVRD_COLR |
Character(1) |
VARCHAR2(1) NOT NULL |
Override User color preference
Y/N Table Edit
Default Value: Y
|
| 7 |
HCSC_ALLOW_HIDING |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Hiding for Manager
Y/N Table Edit
Default Value: Y
|
| 8 |
HCSC_CAL_BGRD_THEM |
Character(1) |
VARCHAR2(1) NOT NULL |
background Theme
C=Color Code
S=Solid Color
Default Value: S
|
| 9 |
HCSC_CAL_BACKGRND |
Character(30) |
VARCHAR2(30) NOT NULL |
Background Color
|
| 10 |
HCSC_CAL_COLOR |
Character(3) |
VARCHAR2(3) NOT NULL |
Display Colour
BLU=Blue
BRN=Brown
GRN=Green
GRY=Gray
LBL=Light blue
LGR=Light green
LGY=Light grey
LYL=Light yellow
ORN=Orange
PNK=Deep pink
RED=Red
RVL=Medium violetred
TAN=Tan
VLT=Violet
YEL=Yellow
|
| 11 |
COLOR_RGB_VALUE |
Character(30) |
VARCHAR2(30) NOT NULL |
Color RGB Value
|
| 12 |
APPCLASS_PATH |
Character(254) |
VARCHAR2(254) NOT NULL |
Application Class Full Path
Prompt Table:
HCSC_CAL_APP_VW
|
| 13 |
APPCLASSID |
Character(30) |
VARCHAR2(30) NOT NULL |
Application Class ID
Prompt Table:
HCSC_CAL_APC_VW
|
| 14 |
CAL_EMPL_DISPLAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Employee Peer View Option in Calendar
H=Hide Details
N=Don't Display
Y=Display Details
Default Value: Y
|