| # |
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 |
CAL_SCH_CONFIG |
Character(1) |
VARCHAR2(1) NOT NULL |
Schedule Configuration in Calendar
A=Active
I=Inactive
Y/N Table Edit
Default Value: Y
|
| 3 |
CAL_HOLIDAY_CONFIG |
Character(1) |
VARCHAR2(1) NOT NULL |
Holiday Configuration in Calendar
A=Active
I=Inactive
Y/N Table Edit
Default Value: Y
|
| 4 |
CAL_WRK_ANI_CONFIG |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Anniversary Configuration in Calendar
A=Active
I=Inactive
Y/N Table Edit
Default Value: Y
|
| 5 |
CAL_BIRTH_CONFIG |
Character(1) |
VARCHAR2(1) NOT NULL |
Birthday Configuration in Calendar
A=Active
I=Inactive
Y/N Table Edit
Default Value: Y
|
| 6 |
CAL_DYOFF_BGD_THEM |
Character(1) |
VARCHAR2(1) NOT NULL |
Day Off background Theme
C=Color Code
S=Solid Color
Default Value: S
|
| 7 |
CAL_DYOFF_BACKGRND |
Character(30) |
VARCHAR2(30) NOT NULL |
Day Off Background Color
|
| 8 |
CAL_DYOFF_COLOR |
Character(3) |
VARCHAR2(3) NOT NULL |
Day Off 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
|
| 9 |
DYOFF_RGB_COLR_VAL |
Character(30) |
VARCHAR2(30) NOT NULL |
Day Off Color RGB Value
|
| 10 |
CAL_ENCAP_BGD_THEM |
Character(1) |
VARCHAR2(1) NOT NULL |
Encapsualte Events background Theme
C=Color Code
S=Solid Color
Default Value: S
|
| 11 |
CAL_ENCAP_BACKGRND |
Character(30) |
VARCHAR2(30) NOT NULL |
Encapsualte Events Background Color
|
| 12 |
CAL_ENCAP_COLOR |
Character(3) |
VARCHAR2(3) NOT NULL |
Encapsualte Events 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
|
| 13 |
ENCAP_RGB_COLR_VAL |
Character(30) |
VARCHAR2(30) NOT NULL |
Encapsualte Events Color RGB Value
|
| 14 |
CAL_TS_BUS_UNIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Schedule Configuration in Calendar
D=Display
H=Hide
Default Value: D
|
| 15 |
CAL_TS_DEPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Schedule Configuration in Calendar
D=Display
H=Hide
Default Value: D
|
| 16 |
CAL_TS_JOB_CODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Schedule Configuration in Calendar
D=Display
H=Hide
Default Value: D
|
| 17 |
CAL_TS_LOCATION |
Character(1) |
VARCHAR2(1) NOT NULL |
Schedule Configuration in Calendar
D=Display
H=Hide
Default Value: D
|
| 18 |
CAL_TS_REPORTS_TO |
Character(1) |
VARCHAR2(1) NOT NULL |
Schedule Configuration in Calendar
D=Display
H=Hide
Default Value: D
|
| 19 |
CAL_TS_SUP_ID |
Character(1) |
VARCHAR2(1) NOT NULL |
Schedule Configuration in Calendar
D=Display
H=Hide
Default Value: D
|