ORG_PLAN_JPNPrompt Table: IDO_ORGPLAN_JPN
BUSINESS_UNITPrompt Table: BUSUNIT_HR_VW
LANGUAGE_CDIDO_HC_JPN_LANG(SQL View) |
Index Back |
|---|---|
Ido Headcount Plan Search RecUsed as a search record allowing a user to enter in both Organization Plan and Business Unit to enter a component. |
| SELECT A.ORG_PLAN_JPN , B.BUSINESS_UNIT , A.LANGUAGE_CD , A.DESCR , B.DESCR FROM PS_IDO_OP_JPN_LNG A , PS_BUS_UNIT_HR_LNG B , PS_BUS_UNIT_TBL_HR C WHERE A.LANGUAGE_CD = B.LANGUAGE_CD AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND C.ACTIVE_INACTIVE = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ORG_PLAN_JPN |
Character(3) | VARCHAR2(3) NOT NULL |
Tracks one possible view of the employees in a company.
Prompt Table: IDO_ORGPLAN_JPN |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: BUSUNIT_HR_VW |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | DESCR2 | Character(30) | VARCHAR2(30) NOT NULL | Descr2 |