HRS_INT_VENUE_IDPrompt Table: HRS_VENUE_TBL
A=Active
I=Inactive
HRS_VENUE_TBL_I(SQL View) |
Index Back |
|---|---|
Venue InformationInterview Venue Information |
| SELECT HRS_INT_VENUE_ID , HRS_INT_VENUE , HRS_VENUE_EMAIL , EFF_STATUS , INTVW_LOCATION , HRS_INT_VEN_NOTE , HRS_INT_VEN_ROOM , HRS_INT_VEN_DIR FROM %Table(HRS_VENUE_TBL) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_INT_VENUE_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Venue ID |
| 2 | HRS_INT_VENUE | Character(50) | VARCHAR2(50) NOT NULL |
Venue for interview
Prompt Table: HRS_VENUE_TBL |
| 3 | HRS_VENUE_EMAIL | Character(70) | VARCHAR2(70) NOT NULL | Venue Email Address |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 5 | INTVW_LOCATION | Character(254) | VARCHAR2(254) NOT NULL | Interview Location |
| 6 | HRS_INT_VEN_NOTE | Character(70) | VARCHAR2(70) NOT NULL | Venue Notes |
| 7 | HRS_INT_VEN_ROOM | Character(70) | VARCHAR2(70) NOT NULL | Interview Room Details |
| 8 | HRS_INT_VEN_DIR | Long Character | CLOB | Interview Venue Directions |