HRS_CAL_USER(SQL Table) | 
Index Back | 
|---|---|
Calendar User InformationTable to capture calendar user information | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(11) | VARCHAR2(11) NOT NULL | 
Employee ID
 Prompt Table: HRS_EMPL_NM_I  | 
|
| 2 | HRS_VENDOR_ID | Number(15,0) | DECIMAL(15) NOT NULL | 
Integration Vendor ID
 Prompt Table: HRS_CAL_SRCH_VW  | 
| 3 | EMAIL_ADDRESS | Long Character | CLOB NOT NULL | Email Addresses | 
| 4 | PASSWORD | Character(254) | VARCHAR2(254) NOT NULL | Password | 
| 5 | HRS_CALENDAR_ID | Number(5,0) | INTEGER NOT NULL | 
Calendar ID
 Prompt Table: HRS_CALENDAR  |