HRS_RES_TMPL_VW(SQL View) |
Index Back |
|---|
| SELECT RP.HRS_RES_TMPL_ID , RP.HRS_PAGE_SEQ , RP.TEXT_ID , RS.RESUME_SECTION_SEQ , RSS.HRS_SEQ_NUM , RS.HRS_SUBSTEP_TXT_ID FROM PS_HRS_RES_TMPL_PG RP , PS_HRS_RES_SECTION RS LEFT OUTER JOIN PS_HRS_RES_SUBSTEP RSS ON RS.HRS_RES_TMPL_ID = RSS.HRS_RES_TMPL_ID AND RS.HRS_PAGE_SEQ = RSS.HRS_PAGE_SEQ AND RS.HRS_SUBSTEP_TXT_ID = RSS.HRS_SUBSTEP_TXT_ID WHERE RP.HRS_RES_TMPL_ID = RS.HRS_RES_TMPL_ID AND RP.HRS_PAGE_SEQ = RS.HRS_PAGE_SEQ |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_RES_TMPL_ID | Number(15,0) | DECIMAL(15) NOT NULL | Resume Template ID |
| 2 | HRS_PAGE_SEQ | Number(3,0) | SMALLINT NOT NULL | Page Sequence |
| 3 | TEXT_ID | Character(18) | VARCHAR2(18) NOT NULL | Text ID |
| 4 | RESUME_SECTION_SEQ | Number(3,0) | SMALLINT NOT NULL | Sequence |
| 5 | HRS_SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 6 | HRS_SUBSTEP_TXT_ID | Character(18) | VARCHAR2(18) NOT NULL | Text ID |