HRS_CALENDAR_ID01=PUBLIC
02=PRIVATE
03=CONFIDENTIAL
04=NORMAL
A=Active
I=Inactive
B=Basic Authentication
P=Proxy Authentication
HRS_CALENDAR(SQL Table) |
Index Back |
|---|---|
Calendar TableTable to add Calendar information |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_CALENDAR_ID |
Number(5,0) | INTEGER NOT NULL | Calendar ID |
| 2 | HRS_DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | HRS_CLASS | Character(2) | VARCHAR2(2) NOT NULL |
Appointment Class
01=PUBLIC 02=PRIVATE 03=CONFIDENTIAL 04=NORMAL |
| 5 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive |
| 6 | HRS_AUTH | Character(2) | VARCHAR2(2) NOT NULL |
Authentication Type
B=Basic Authentication P=Proxy Authentication |
| 7 | HRS_APPLICTN_NAME | Character(30) | VARCHAR2(30) NOT NULL | Application Name |
| 8 | HRS_APPLICTN_PSWD | Character(254) | VARCHAR2(254) NOT NULL | Application Password |