LM_JOBCODE_IDDefault Value: %date
LM_JOB_EFFDT_VW(SQL View) |
Index Back |
|---|---|
Job Effdt ViewReturns valid effective dates per a particular job code id. |
| SELECT LM_JOBCODE_ID , EFFDT FROM PS_LM_PERS_HRJOBVW |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_JOBCODE_ID |
Number(15,0) | DECIMAL(15) NOT NULL | JobCode ID |
| 2 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |