HRS_PERSON_IDHRS_PROFILE_SEQSTART_DTSEQUENCE_NBRHRS_APP_W_EX_VW(SQL View) |
Index Back |
|---|---|
App Prior Work ExperienceApp Prior Work Experience |
| SELECT DISTINCT A.HRS_PERSON_ID , A.HRS_PROFILE_SEQ , A.START_DT , A.SEQUENCE_NBR FROM PS_HRS_APP_WRK_EXP A WHERE A.hrs_profile_seq = ( SELECT MAX(B.hrs_profile_seq) FROM PS_HRS_APP_WRK_EXP B WHERE B.HRS_PERSON_ID = A.HRS_PERSON_ID AND b.start_dt = A.start_dt) AND A.SEQUENCE_NBR = ( SELECT MAX(B.SEQUENCE_NBR) FROM PS_HRS_APP_WRK_EXP B WHERE B.HRS_PERSON_ID = a.hrs_person_id AND b.start_dt = A.start_dt AND b.hrs_profile_seq = a.hrs_profile_seq) |
| # | 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 | START_DT |
Date(10) | DATE | Start Date |
| 4 | SEQUENCE_NBR |
Number(2,0) | SMALLINT NOT NULL | Sequence Number |