EMPLIDF=Female
M=Male
U=Unknown
GPIN_SS_12BB_VW(SQL View) |
Index Back |
|---|---|
Fetch Personal data - Form12BBFetch Personal data - Form12BB |
| SELECT A.EMPLID , A.NAME_DISPLAY , A.SEX , B1.GPIN_NBR_CHILD , D.HIRE_DT , D.JOBCODE , C1.DESCR , E1.NATIONAL_ID , F.DESCR FROM ((PS_PERSONAL_DATA A LEFT OUTER JOIN ( SELECT B.EMPLID ,B.GPIN_NBR_CHILD ,B.ESTABID FROM PS_GPIN_TDS_GEN B WHERE B.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PS_GPIN_TDS_GEN B_ED WHERE B.EMPLID = B_ED.EMPLID AND B_ED.EFFDT <= %CurrentDateIn)) B1 ON A.EMPLID = B1.EMPLID) LEFT OUTER JOIN ( SELECT C.ESTABID ,C.DESCR FROM PS_ESTAB_TBL C WHERE C.EFFDT = ( SELECT MAX(C_ED.EFFDT) FROM PS_ESTAB_TBL C_ED WHERE C.ESTABID = C_ED.ESTABID AND C_ED.EFFDT <= %CurrentDateIn AND C.EFF_STATUS = 'A' )) C1 ON C1.ESTABID = B1.ESTABID) , (PS_JOB D LEFT OUTER JOIN ( SELECT E.EMPLID ,E.NATIONAL_ID FROM PS_PERS_NID E WHERE E.COUNTRY = 'IND' AND E.NATIONAL_ID_TYPE = 'PAN') E1 ON E1.EMPLID = D.EMPLID ), PS_JOBCODE_TBL F WHERE A.EMPLID = D.EMPLID AND D.EFFDT = ( SELECT MAX(D_ED.EFFDT) FROM PS_JOB D_ED WHERE D.EMPLID = D_ED.EMPLID AND D.EMPL_RCD = D_ED.EMPL_RCD AND D_ED.EFFDT <= %CurrentDateIn ) AND D.EFFSEQ = ( SELECT MAX(D_ES.EFFSEQ) FROM PS_JOB D_ES WHERE D.EMPLID = D_ES.EMPLID AND D.EMPL_RCD = D_ES.EMPL_RCD AND D.EFFDT = D_ES.EFFDT ) AND D.HR_STATUS = 'A' AND D.REG_REGION = 'IND' AND D.JOB_INDICATOR = 'P' AND F.EFFDT = ( SELECT MAX(F_ED.EFFDT) FROM PS_JOBCODE_TBL F_ED WHERE F.SETID = F_ED.SETID AND F.JOBCODE = F_ED.JOBCODE AND F_ED.EFFDT <= %CurrentDateIn ) AND F.SETID = D.SETID_JOBCODE AND F.JOBCODE = D.JOBCODE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 3 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender
F=Female M=Male U=Unknown |
| 4 | GPIN_NBR_CHILD | Number(2,0) | SMALLINT NOT NULL | Number of Children |
| 5 | HIRE_DT | Date(10) | DATE | First Start Date |
| 6 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 8 | NATIONAL_ID | Character(20) | VARCHAR2(20) NOT NULL | National ID |
| 9 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |