PROCESS_INSTANCEOPRIDRUN_CNTL_IDEMPLIDPrompt Table: PERS_SRCH_GBL
EMPL_RCDORG_INSTANCE_ERNEFFDTDefault Value: %date
Prompt Table: ACTN_REASON_TBL
C=Cancel
F=Failure
R=Ready
S=Success
Default Value: R
Y/N Table Edit
HCR_OC_ASG_AET(SQL Table) |
Index Back |
|---|---|
AE Cache Table for Promote AsgCache record used for App Engine HC_OC_ASG Promote an assignment to an instance |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERS_SRCH_GBL |
| 5 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 6 | ORG_INSTANCE_ERN |
Number(3,0) | SMALLINT NOT NULL | Indicates which EMPL_RCD (ERN) is considered the Organizational Instance for this particular ERN. An Organizational Instance defines an Instance of Employment or an Instance of Contingent Workforce. Hire, Termination, and Service dates are captured at the Organiational Instance level. |
| 7 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 8 | ACTION | Character(3) | VARCHAR2(3) NOT NULL | Action |
| 9 | ACTION_REASON | Character(3) | VARCHAR2(3) NOT NULL |
Reason Code
Prompt Table: ACTN_REASON_TBL |
| 10 | HCR_OC_EXEC_ST_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Organization Changes - Promote an assignment to an instance
Execution status flag
C=Cancel F=Failure R=Ready S=Success Default Value: R |
| 11 | HCR_OC_EXEC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Organization Changes - Promote an assignment to an instance
Execute flag
Y/N Table Edit |