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 | EMPLID | 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 |