OPRIDRUN_CNTL_IDPrompt Table: TC_PLAN_VW1
Prompt Table: TC_PLAN_VW
Prompt Table: TC_SRCADHORG_VW
Prompt Table: TC_CMPADHORG_VW
Prompt Table: GB_GROUP_SEC_VW
Prompt Table:
CURRENCY_CD_TBL
Set Control Field: CURRENCY_CD
TC_RUNCTL_ADHOC(SQL Table) |
Index Back |
|---|---|
Total Comp Adhoc Org Run CntlRun Control use to generate ad-hoc compensation amounts in Report Total Compensation. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | TC_PLAN_ID | Character(10) | VARCHAR2(10) NOT NULL |
Total Comp Plan ID
Prompt Table: TC_PLAN_VW1 |
| 4 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Prompt Table: TC_PLAN_VW |
| 5 | TC_COMP_SOURCE_ID | Character(10) | VARCHAR2(10) NOT NULL |
Compensation Source
Prompt Table: TC_SRCADHORG_VW |
| 6 | COMPENSATION_ID | Character(10) | VARCHAR2(10) NOT NULL |
Compensation ID
Prompt Table: TC_CMPADHORG_VW |
| 7 | GB_GROUP_ID | Character(15) | VARCHAR2(15) NOT NULL |
Group Build ID.
Prompt Table: GB_GROUP_SEC_VW |
| 8 | ASOFDATE | Date(10) | DATE | As of Date |
| 9 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 10 | FROM_DATE | Date(10) | DATE | From Date |
| 11 | THRU_DATE | Date(10) | DATE | Thru Date |
| 12 | AMOUNT | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Commuting Allowance Paid Per Cycle. |