EMPLIDDefault Value: NEW
Prompt Table: PERSON
GPIN_JBTITLE_VW(SQL View) |
Index Back |
|---|---|
Job TitleJob Title view for Payroll India |
| SELECT a.emplid ,a.jobcode ,b.descr FROM ps_job a , PS_JOBCODE_TBL b WHERE a.jobcode = b.jobcode AND a.setid_jobcode = b.setid |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Default Value: NEW Prompt Table: PERSON |
| 2 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |