HRS_JO_DESCR_TYPPrompt Table: HRS_DSC_TYP_VW
HRS_JO_PST_LIB_CDHRS_JPST_LIB_VW(SQL View) |
Index Back |
|---|---|
Job Opening Posting LibraryJob Opening Posting Library |
| SELECT HRS_JO_DESCR_TYP , HRS_JO_PST_LIB_CD , DESCR50 , DESCRLONG FROM PS_HRS_JO_PST_LIB WHERE HRS_JO_DESCR_TYP IN ( SELECT HRS_JO_DESCR_TYP FROM PS_HRS_DSC_TYP_VW) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_JO_DESCR_TYP |
Character(2) | VARCHAR2(2) NOT NULL |
Job posting description type
Prompt Table: HRS_DSC_TYP_VW |
| 2 | HRS_JO_PST_LIB_CD |
Character(3) | VARCHAR2(3) NOT NULL | Description ID |
| 3 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 4 | DESCRLONG | Long Character | CLOB | Long Description |