HCSC_CAL_PRF_VW

(SQL View)
 Index Back

Calendar User Prefrences

Calendar User Prefrences

SELECT A.OPRID , A.HCSC_CAL_EVENT_ID , B.HCSC_CAL_EVT_NAME , A.HCSC_CAL_BGRD_THEM , A.HCSC_CAL_BACKGRND , A.HCSC_CAL_COLOR , B.HCSC_CAL_STATUS , A.SHOW_IN_CAL , B.HCSC_CAL_OVRD_COLR , B.HCSC_ALLOW_HIDING , B.IMAGE_NAME , A.COLOR_RGB_VALUE , B.HCSC_CAL_STATUS , B.HCSC_CAL_ORD_NUM FROM PS_HCSC_CAL_USPREF A , PS_HCSC_CAL_EVTDEF B , PS_HCSC_CAL_ROLES C WHERE B.HCSC_CAL_STATUS = 'A' AND A.HCSC_CAL_EVENT_ID = B.HCSC_CAL_EVENT_ID AND A.HCSC_CAL_EVENT_ID = C.HCSC_CAL_EVENT_ID AND EXISTS ( SELECT 'X' FROM PSROLEUSER X WHERE X.ROLEUSER = A.OPRID AND X.ROLENAME = C.ROLENAME) UNION SELECT OPR.OPRID , B.HCSC_CAL_EVENT_ID , B.HCSC_CAL_EVT_NAME , B.HCSC_CAL_BGRD_THEM , B.HCSC_CAL_BACKGRND , B.HCSC_CAL_COLOR ,B.HCSC_CAL_STATUS ,CASE WHEN B.HCSC_CAL_STATUS = 'A' THEN 'Y' ELSE 'N' END , B.HCSC_CAL_OVRD_COLR ,B.HCSC_ALLOW_HIDING , B.IMAGE_NAME , B.COLOR_RGB_VALUE , B.HCSC_CAL_STATUS , B.HCSC_CAL_ORD_NUM FROM PS_HCSC_CAL_EVTDEF B , PSOPRDEFN OPR , PS_HCSC_CAL_ROLES C WHERE B.HCSC_CAL_STATUS = 'A' AND B.HCSC_CAL_EVENT_ID = C.HCSC_CAL_EVENT_ID AND NOT EXISTS ( SELECT 'X' FROM PS_HCSC_CAL_USPREF X WHERE X.HCSC_CAL_EVENT_ID = B.HCSC_CAL_EVENT_ID AND OPR.OPRID = X.OPRID) AND EXISTS ( SELECT 'X' FROM PSROLEUSER X WHERE X.ROLEUSER = OPR.OPRID AND X.ROLENAME = C.ROLENAME)

# 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 HCSC_CAL_EVENT_ID Character(12) VARCHAR2(12) NOT NULL Transaction or Event Type ID
3 HCSC_CAL_EVT_NAME Character(30) VARCHAR2(30) NOT NULL Transaction or Event Name
4 HCSC_CAL_BGRD_THEM Character(1) VARCHAR2(1) NOT NULL background Theme
C=Color Code
S=Solid Color
5 HCSC_CAL_BACKGRND Character(30) VARCHAR2(30) NOT NULL Background Color
6 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
7 HCSC_CAL_STATUS Character(1) VARCHAR2(1) NOT NULL Transaction or Event Status
A=Active
I=Inactive
8 SHOW_IN_CAL Character(1) VARCHAR2(1) NOT NULL Transaction or Event Status

Y/N Table Edit

9 HCSC_CAL_OVRD_COLR Character(1) VARCHAR2(1) NOT NULL Override User color preference
10 HCSC_ALLOW_HIDING Character(1) VARCHAR2(1) NOT NULL Allow Hiding for Manager
11 IMAGE_NAME Character(30) VARCHAR2(30) NOT NULL The name of images used in Personalizations explanations.
12 COLOR_RGB_VALUE Character(30) VARCHAR2(30) NOT NULL Color RGB Value
13 EVENT_STATUS Character(1) VARCHAR2(1) NOT NULL Event Status
C=Closed to Processing
D=Disconnected from Job Record
O=Open for Processing
V=Void
14 HCSC_CAL_ORD_NUM Number(3,0) SMALLINT NOT NULL Sequence or Order number