TC_JOBCODE_VW(SQL View) |
Index Back |
---|---|
Job CodesUse JOBCODE_TBL to record information about the job assignments in your company. Assign a job code to each job. Data includes description, salary grade, standard hours, and salary survey equivalents. You can create multiple JOBCODE_TBL records for a job code, each with a unique effective date. |
SELECT A.SETID , A.JOBCODE , A.EFFDT , A.SETID %Concat A.JOBCODE , A.DESCR FROM PS_JOBCODE_TBL A WHERE A.EFF_STATUS = 'A' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_HR.SETID Prompt Table: SET_VLD_HR_02 |
2 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
3 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
4 | TC_SETID_JOBCODE | Character(11) | VARCHAR2(11) NOT NULL | Job Code |
5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |