HRS_PERSON_IDHRS_PROFILE_SEQHRS_BIP_FED_VW(SQL View) |
Index Back |
|---|---|
Federal Preferences ViewThis view returns descriptions for Federal preferences on Recruiting applications. |
| SELECT A.HRS_PERSON_ID , A.HRS_PROFILE_SEQ , HCP.DESCR , PP.DESCR , PP3.DESCR , PRF.DESCR , ' ' , ' ' FROM PS_HRS_APP_PROFILE A LEFT OUTER JOIN PS_HRS_GVT_HCP_VW HCP ON HCP.GVT_DISABILITY_CD = A.GVT_DISABILITY_CD LEFT OUTER JOIN PS_HRS_GVT_PPLN_VW PP ON PP.GVT_PAY_PLAN = A.GVT_HIGH_PAY_PLAN LEFT OUTER JOIN PS_HRS_GVT_PPLN_VW PP3 ON PP3.GVT_PAY_PLAN = A.GVT_PAY_PLAN LEFT OUTER JOIN PS_HRS_VTPRF_VW PRF ON PRF.GVT_VET_PREF_APPT = A.GVT_VET_PREF_APPT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Person Id |
| 2 | HRS_PROFILE_SEQ |
Number(3,0) | SMALLINT NOT NULL | Profile sequece |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |
| 5 | DESCR2 | Character(30) | VARCHAR2(30) NOT NULL | Descr2 |
| 6 | DESCR3 | Character(30) | VARCHAR2(30) NOT NULL | Descr 3 |
| 7 | DESCR4 | Character(30) | VARCHAR2(30) NOT NULL | Descr 4 |
| 8 | DESCR5 | Character(30) | VARCHAR2(30) NOT NULL | This field is used in a complex query that shows many descr fields. |