ORG_PLAN_JPNPrompt Table: IDO_ORGPLAN_JPN
EMPLIDPrompt Table: ACTIVE_WRKR_VW
EMPL_RCDPrompt Table: EE_RCD_JPN_VW
IDO_CAND_JPN_VW(SQL View) |
Index Back |
|---|---|
Ido Candidates ViewThis view is used to create the Unassigned Candidate list on the Tamatsuki Post page. |
| SELECT A.ORG_PLAN_JPN , A.EMPLID , A.EMPL_RCD , B.ORG_DATE_JPN FROM PS_IDO_CANDIDT_JPN A , PS_IDO_ORGPLAN_JPN B WHERE A.ORG_PLAN_JPN = B.ORG_PLAN_JPN |
| # | 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 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: ACTIVE_WRKR_VW |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL |
Empl Record
Prompt Table: EE_RCD_JPN_VW |
| 4 | EFFDT | Date(10) | DATE | Effective Date |