EMPLIDSSR_BRHO_ENRSQ_NLDSSR_BRHO_RESEQ_NLDSSR_BRH_BND_DEL(SQL View) |
Index Back |
|---|---|
Delivery Process Bind Record |
| SELECT DISTINCT P.EMPLID , S.SSR_BRHO_ENRSQ_NLD ,S.SSR_BRHO_RESEQ_NLD FROM PS_HCR_PERSON_I P , PS_SSR_STD_PRG_NLD S WHERE P.EMPLID = S.EMPLID AND (S.SSR_BRHO_ENRSQ_NLD <> ' ' OR S.SSR_BRHO_RESEQ_NLD <> ' ') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | SSR_BRHO_ENRSQ_NLD |
Character(20) | VARCHAR2(20) NOT NULL | BRON Enrolment Seq Nbr |
| 3 | SSR_BRHO_RESEQ_NLD |
Character(20) | VARCHAR2(20) NOT NULL | BRON Result Seq Nbr |