POSITION_NBRPrompt Table: CM_POSN_ALL_VW
SETIDDefault Value: OPR_DEF_TBL_HR.SETID
Prompt Table: CM_ROLESETID_VW
JOBCODEPrompt Table: CM_JOBCD_ALL_VW
JOB_TASKPrompt Table: CM_TASK_ALL_VW
EFFDTCM_ROLE_SRCH(SQL View) |
Index Back |
|---|---|
Role Match SearchCM_ROLE_SRCH is a search record that selects roles (positions, jobcodes, or job tasks). |
| SELECT A.POSITION_NBR , A.SETID , A.JOBCODE , A.JOB_TASK , A.EFFDT FROM PS_CM_ROLE A WHERE A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_CM_ROLE WHERE A.POSITION_NBR = POSITION_NBR AND A.SETID = SETID AND A.JOBCODE = JOBCODE AND A.JOB_FAMILY = JOB_FAMILY AND A.JOB_TASK = JOB_TASK AND EFFDT <= %CurrentDateIn) AND A.JOB_FAMILY = ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | POSITION_NBR |
Character(8) | VARCHAR2(8) NOT NULL |
Position Number
Prompt Table: CM_POSN_ALL_VW |
| 2 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_HR.SETID Prompt Table: CM_ROLESETID_VW |
| 3 | JOBCODE |
Character(6) | VARCHAR2(6) NOT NULL |
Job Code
Prompt Table: CM_JOBCD_ALL_VW |
| 4 | JOB_TASK |
Character(6) | VARCHAR2(6) NOT NULL |
Job Task
Prompt Table: CM_TASK_ALL_VW |
| 5 | EFFDT |
Date(10) | DATE | Effective Date |