EMPLIDPrompt Table: PERSON
JPM_CAT_ITEM_IDDT_ISSUEDMAJOR_CODEHR_CP_MEMB_VW(SQL View) |
Index Back |
|---|---|
Employee Resume ProMembershipsIs used for the Professional Memberships grid on the Employee Self-Service Internal Resume and as data for the Individual Development Plan. |
| SELECT DISTINCT A.EMPLID ,%Substring(B.JPM_CAT_ITEM_ID,1,8) , B.EFFDT ,B.MAJOR_CODE , %Substring(C.JPM_DESCR90,1,30) ,%Substring(B.JPM_TEXT254_2,1,15) ,%Substring(B.JPM_TEXT254_3,1,15) ,B.JPM_DATE_2 ,B.JPM_DATE_3 FROM PS_HR_CP_CAT_VW A , PS_JPM_JP_ITEMS B , PS_JPM_CAT_ITEMS C WHERE A.JPM_PROFILE_ID = B.JPM_PROFILE_ID AND A.JPM_CAT_TYPE = B.JPM_CAT_TYPE AND A.JPM_CAT_TYPE = C.JPM_CAT_TYPE AND B.JPM_CAT_ITEM_ID = C.JPM_CAT_ITEM_ID AND A.JPM_CAT_TYPE = 'MEM' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | JPM_CAT_ITEM_ID |
Character(12) | VARCHAR2(12) NOT NULL | Catalog Item Id. Identifies a unique catalog item defintion within a catalog type. |
| 3 | DT_ISSUED |
Date(10) | DATE | Issue Date |
| 4 | MAJOR_CODE |
Character(10) | VARCHAR2(10) NOT NULL | Major Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | MANDATE | Character(15) | VARCHAR2(15) NOT NULL | Mandate |
| 7 | MANDATE_FUNCTION | Character(15) | VARCHAR2(15) NOT NULL | Mandate Position |
| 8 | MANDATE_BEGIN_DATE | Date(10) | DATE | Mandate Begin Date |
| 9 | MANDATE_END_DATE | Date(10) | DATE | Mandate End Date |