LM_JP_TYPELM_JP_SECTION_IDEFFDTDefault Value: %date
LM_FIELDNAMELM_JP_PROPS_VW(SQL View) |
Index Back |
|---|---|
Profile PropertiesProfile Properties |
| SELECT A.LM_JP_TYPE , A.LM_JP_SECTION_ID , A.EFFDT , A.LM_FIELDNAME , B.LM_CAT_TYPE FROM PS_LM_JP_PROPS A , PS_LM_JP_SECTION B WHERE A.LM_JP_TYPE = B.LM_JP_TYPE AND A.LM_JP_SECTION_ID = B.LM_JP_SECTION_ID AND A.EFFDT = B.EFFDT AND A.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_LM_JP_PROPS C WHERE A.LM_JP_TYPE = C.LM_JP_TYPE AND A.LM_JP_SECTION_ID = C.LM_JP_SECTION_ID AND C.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_JP_TYPE |
Character(12) | VARCHAR2(12) NOT NULL | Job Profile Types |
| 2 | LM_JP_SECTION_ID |
Number(4,0) | SMALLINT NOT NULL | Section ID |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | LM_FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Used to hold the field name. |
| 5 | LM_CAT_TYPE | Character(12) | VARCHAR2(12) NOT NULL | Category Type |