GROUP_IDPrompt Table: TL_GROUP_TBL
EMPLIDPrompt Table: TL_GROUP_DTL
EMPL_RCDTL_GROUP_DTL_VW(SQL View) |
Index Back |
|---|---|
Group Detail ViewGroup Detail View |
| SELECT A.GROUP_ID , A.EMPLID , A.EMPL_RCD , B.NAME , C.DESCR FROM PS_TL_GROUP_DTL A , PS_PERSON_NAME B , PS_JOBCODE_TBL C , PS_JOB D WHERE A.EMPLID = B.EMPLID AND D.EMPLID =A.EMPLID AND D.EMPL_RCD = A.EMPL_RCD AND D.EFFDT = ( SELECT MAX(D1.EFFDT) FROM PS_JOB D1 WHERE D1.EMPLID = D.EMPLID AND D1.EMPL_RCD = D.EMPL_RCD AND D1.EFFDT <= %CurrentDateIn) AND D.EFFSEQ = ( SELECT MAX(D2.EFFSEQ) FROM PS_JOB D2 WHERE D2.EMPLID = D.EMPLID AND D2.EMPL_RCD = D.EMPL_RCD AND D2.EFFDT = D.EFFDT) AND C.JOBCODE = D.JOBCODE AND C.SETID = D.SETID_JOBCODE AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_JOBCODE_TBL C1 WHERE C1.JOBCODE = C.JOBCODE AND C1.SETID = C.SETID AND C1.EFFDT <= D.EFFDT) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GROUP_ID |
Character(5) | VARCHAR2(5) NOT NULL |
Group ID
Prompt Table: TL_GROUP_TBL |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: TL_GROUP_DTL |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 4 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 5 | JOBTITLE | Character(30) | VARCHAR2(30) NOT NULL | Job Title |