Parameters for Work Structure Extensible and Descriptive Flexfields
Flexfield segments have list of values that are dependent on standard attributes. Workforce structure attributes can be used as these objects:
- Flexfield parameters for workforce structure descriptive flexfields.
- Input parameters when creating a value set for a flexfield segment.
You can use workforce structure attributes and descriptive flexfields as parameters when you configure workforce structure extensible flexfields (EFF) and workforce structure descriptive flexfields (DFF).
Note: If you have configured the value set or default conditions using
parameters for the EFF, these values will be reinitialized only when you navigate to
the EFF field.
Grades
This table shows the parameters that you can use for these grade workforce structures EFF.
- PER_GRADES_LEG_EFF
| Flexfield Code | Parameter Code | Data Type | Parameter Description |
|---|---|---|---|
| PER_GRADES_LEG_EFF | EFFECTIVE_START_DATE | DATE | Effective Start Date |
Jobs
This table shows the parameters that you can use for these job workforce structures DFF and EFF.
- PER_JOBS_DFF
- PER_JOBS_EIT_EFF
- PER_JOBS_LEG_EFF
| Flexfield Code | Parameter Code | Data Type | Parameter Description |
|---|---|---|---|
| PER_JOBS_DFF | EFFECTIVE_START_DATE | DATE | Effective Start Date |
| PER_JOBS_DFF | SET_ID | NUMBER | Set ID |
| PER_JOBS_EIT_EFF | EFFECTIVE_START_DATE | DATE | Effective Start Date |
| PER_JOBS_EIT_EFF | SET_ID | NUMBER | Set ID |
| PER_JOBS_LEG_EFF | EFFECTIVE_START_DATE | DATE | Effective Start Date |
Locations
This table shows the parameters that you can use for these location workforce structures DFF and EFF.
- PER_LOCATIONS_DF
- PER_LOCATION_INFORMATION_EFF
- PER_LOCATION_LEG_EFF
| Flexfield Code | Parameter Code | Data Type | Parameter Description |
|---|---|---|---|
| PER_LOCATIONS_DF | EFFECTIVE_START_DATE | DATE | Effective Start Date |
| PER_LOCATIONS_DF | SET_ID | NUMBER | Set ID |
| PER_LOCATION_INFORMATION_EFF | ACTION_REASON_CODE | VARCHAR2 | Action Reason Code |
| PER_LOCATION_INFORMATION_EFF | ACTIVE_STATUS_CODE | VARCHAR2 | Active Status Code |
| PER_LOCATION_INFORMATION_EFF | ADDRESS_LINE_1 | VARCHAR2 | ADDRESS_LINE_1 |
| PER_LOCATION_INFORMATION_EFF | ADDRESS_LINE_2 | VARCHAR2 | ADDRESS_LINE_2 |
| PER_LOCATION_INFORMATION_EFF | ADDRESS_LINE_3 | VARCHAR2 | ADDRESS_LINE_3 |
| PER_LOCATION_INFORMATION_EFF | ADDRESS_LINE_4 | VARCHAR2 | ADDRESS_LINE_4 |
| PER_LOCATION_INFORMATION_EFF | BILL_TO_SITE | VARCHAR2 | Bill-to Site Flag |
| PER_LOCATION_INFORMATION_EFF | BUILDING | VARCHAR2 | BUILDING |
| PER_LOCATION_INFORMATION_EFF | COUNTRY | VARCHAR2 | COUNTRY |
| PER_LOCATION_INFORMATION_EFF | DESIGNATED_RECEIVER_ID | NUMBER | Designated Receiver ID |
| PER_LOCATION_INFORMATION_EFF | DESIGNATED_RECEIVER_LIST_NAME | VARCHAR2 | Designated Receiver List Name |
| PER_LOCATION_INFORMATION_EFF | EFFECTIVE_END_DATE | DATE | Effective End Date |
| PER_LOCATION_INFORMATION_EFF | EFFECTIVE_START_DATE | DATE | Effective Start Date |
| PER_LOCATION_INFORMATION_EFF | FLOOR_NUMBER | VARCHAR2 | FLOOR_NUMBER |
| PER_LOCATION_INFORMATION_EFF | GEOGRAPHIC_HIEARCHY_CODE | VARCHAR2 | Geographic Hierarchy Code |
| PER_LOCATION_INFORMATION_EFF | INTERNAL_LOCATION_CODE | VARCHAR2 | Location Code |
| PER_LOCATION_INFORMATION_EFF | INVENTORY_ORGANIZATION_CODE | VARCHAR2 | Inventory Organization Code |
| PER_LOCATION_INFORMATION_EFF | LEGISLATION_CODE | VARCHAR2 | Legislation Code |
| PER_LOCATION_INFORMATION_EFF | LOCATION_ID | NUMBER | Location ID |
| PER_LOCATION_INFORMATION_EFF | OFFICE_SITE | VARCHAR2 | Office Site Flag |
| PER_LOCATION_INFORMATION_EFF | POSTAL_CODE | VARCHAR2 | POSTAL_CODE |
| PER_LOCATION_INFORMATION_EFF | RECEIVING_SITE | VARCHAR2 | Receiving Site Flag |
| PER_LOCATION_INFORMATION_EFF | REGION_1 | VARCHAR2 | REGION_1 |
| PER_LOCATION_INFORMATION_EFF | REGION_2 | VARCHAR2 | REGION_2 |
| PER_LOCATION_INFORMATION_EFF | REGION_3 | VARCHAR2 | REGION_3 |
| PER_LOCATION_INFORMATION_EFF | SET_CODE | VARCHAR2 | Set Code |
| PER_LOCATION_INFORMATION_EFF | SET_ID | NUMBER | Set ID |
| PER_LOCATION_INFORMATION_EFF | SHIP_TO_LOCATION_CODE | VARCHAR2 | Ship-to Location Code |
| PER_LOCATION_INFORMATION_EFF | SHIP_TO_LOCATION_SET_ID | NUMBER | Ship-to Location Set ID |
| PER_LOCATION_INFORMATION_EFF | SHIP_TO_SITE_FLAG | VARCHAR2 | Ship-to Site Flag |
| PER_LOCATION_INFORMATION_EFF | TOWN_OR_CITY | VARCHAR2 | TOWN_OR_CITY |
| PER_LOCATION_LEG_EFF | ACTION_REASON_CODE | VARCHAR2 | Action Reason Code |
| PER_LOCATION_LEG_EFF | ACTIVE_STATUS_CODE | VARCHAR2 | Active Status Code |
| PER_LOCATION_LEG_EFF | ADDRESS_LINE_1 | VARCHAR2 | ADDRESS_LINE_1 |
| PER_LOCATION_LEG_EFF | ADDRESS_LINE_2 | VARCHAR2 | ADDRESS_LINE_2 |
| PER_LOCATION_LEG_EFF | ADDRESS_LINE_3 | VARCHAR2 | ADDRESS_LINE_3 |
| PER_LOCATION_LEG_EFF | ADDRESS_LINE_4 | VARCHAR2 | ADDRESS_LINE_4 |
| PER_LOCATION_LEG_EFF | BILL_TO_SITE | VARCHAR2 | Bill-to Site Flag |
| PER_LOCATION_LEG_EFF | BUILDING | VARCHAR2 | BUILDING |
| PER_LOCATION_LEG_EFF | COUNTRY | VARCHAR2 | COUNTRY |
| PER_LOCATION_LEG_EFF | DESIGNATED_RECEIVER_ID | NUMBER | Designated Receiver ID |
| PER_LOCATION_LEG_EFF | DESIGNATED_RECEIVER_LIST_NAME | VARCHAR2 | Designated Receiver List Name |
| PER_LOCATION_LEG_EFF | EFFECTIVE_END_DATE | DATE | Effective End Date |
| PER_LOCATION_LEG_EFF | EFFECTIVE_START_DATE | DATE | Effective Start Date |
| PER_LOCATION_LEG_EFF | FLOOR_NUMBER | VARCHAR2 | FLOOR_NUMBER |
| PER_LOCATION_LEG_EFF | GEOGRAPHIC_HIEARCHY_CODE | VARCHAR2 | Geographic Hierarchy Code |
| PER_LOCATION_LEG_EFF | INTERNAL_LOCATION_CODE | VARCHAR2 | Location Code |
| PER_LOCATION_LEG_EFF | INVENTORY_ORGANIZATION_CODE | VARCHAR2 | Inventory Organization Code |
| PER_LOCATION_LEG_EFF | LEGISLATION_CODE | VARCHAR2 | Legislation Code |
| PER_LOCATION_LEG_EFF | LOCATION_ID | NUMBER | Location ID |
| PER_LOCATION_LEG_EFF | OFFICE_SITE | VARCHAR2 | Office Site Flag |
| PER_LOCATION_LEG_EFF | POSTAL_CODE | VARCHAR2 | POSTAL_CODE |
| PER_LOCATION_LEG_EFF | RECEIVING_SITE | VARCHAR2 | Receiving Site Flag |
| PER_LOCATION_LEG_EFF | REGION_1 | VARCHAR2 | REGION_1 |
| PER_LOCATION_LEG_EFF | REGION_2 | VARCHAR2 | REGION_2 |
| PER_LOCATION_LEG_EFF | REGION_3 | VARCHAR2 | REGION_3 |
| PER_LOCATION_LEG_EFF | SET_CODE | VARCHAR2 | Set Code |
| PER_LOCATION_LEG_EFF | SHIP_TO_LOCATION_CODE | VARCHAR2 | Ship-to Location Code |
| PER_LOCATION_LEG_EFF | SHIP_TO_LOCATION_SET_ID | NUMBER | Ship-to Location Set ID |
| PER_LOCATION_LEG_EFF | SHIP_TO_SITE_FLAG | VARCHAR2 | Ship-to Site Flag |
| PER_LOCATION_LEG_EFF | TOWN_OR_CITY | VARCHAR2 | TOWN_OR_CITY |
Organizations
This table shows the parameters that you can use for these organization workforce structures DFF and EFF.
- PER_ORGANIZATION_UNIT_DFF
- PER_ORGANIZATION_INFORMATION_EFF
| Flexfield Code | Parameter Code | Data Type | Parameter Description |
|---|---|---|---|
| PER_ORGANIZATION_UNIT_DFF | EFFECTIVE_START_DATE | DATE | Effective Start Date |
| PER_ORGANIZATION_UNIT_DFF | ORGANIZATION_ID | NUMBER | Organization Id |
| PER_ORGANIZATION_UNIT_DFF | SET_ID | NUMBER | Set ID |
| PER_ORGANIZATION_INFORMATION_EFF | EFFECTIVE_START_DATE | DATE | Effective Start Date |
| PER_ORGANIZATION_INFORMATION_EFF | ORGANIZATION_ID | NUMBER | Organization Id |
| PER_ORGANIZATION_INFORMATION_EFF | SET_ID | NUMBER | Set Id |
Positions
This table shows the parameters that you can use for these position workforce structures DFF and EFF.
- PER_POSITIONS_DFF
- PER_POSITIONS_EIT_EFF
- PER_POSITIONS_LEG_EFF
| Flexfield Code | Parameter Code | Data Type | Parameter Description |
|---|---|---|---|
| PER_POSITIONS_DFF | ASSIGNMENT_CATEGORY | VARCHAR2 | Assignment Category |
| PER_POSITIONS_DFF | BARGAINING_UNIT_CD | VARCHAR2 | Bargaining Unit Code |
| PER_POSITIONS_DFF | BUSINESS_UNIT_ID | NUMBER | Business Unit Id |
| PER_POSITIONS_DFF | COLLECTIVE_AGREEMENT_ID | NUMBER | Collective Agreement Id |
| PER_POSITIONS_DFF | EFFECTIVE_END_DATE | DATE | Effective End Date |
| PER_POSITIONS_DFF | EFFECTIVE_START_DATE | DATE | Effective Start Date |
| PER_POSITIONS_DFF | ENTRY_GRADE_ID | NUMBER | Entry Grade Id |
| PER_POSITIONS_DFF | ENTRY_STEP_ID | NUMBER | Entry Step Id |
| PER_POSITIONS_DFF | GRADE_LADDER_ID | NUMBER | Grade Ladder Id |
| PER_POSITIONS_DFF | JOB_ID | NUMBER | Job Id |
| PER_POSITIONS_DFF | LOCATION_ID | NUMBER | Location Id |
| PER_POSITIONS_DFF | ORGANIZATION_ID | NUMBER | Organization Id |
| PER_POSITIONS_DFF | UNION_ID | NUMBER | Union Id |
| PER_POSITIONS_EIT_EFF | ASSIGNMENT_CATEGORY | VARCHAR2 | Assignment Category |
| PER_POSITIONS_EIT_EFF | BARGAINING_UNIT_CD | VARCHAR2 | Bargaining Unit Code |
| PER_POSITIONS_EIT_EFF | BUSINESS_UNIT_ID | NUMBER | Business Unit |
| PER_POSITIONS_EIT_EFF | COLLECTIVE_AGREEMENT_ID | NUMBER | Collective Agreement |
| PER_POSITIONS_EIT_EFF | EFFECTIVE_END_DATE | DATE | Effective End Date |
| PER_POSITIONS_EIT_EFF | EFFECTIVE_START_DATE | DATE | Effective Start Date |
| PER_POSITIONS_EIT_EFF | ENTRY_GRADE_ID | NUMBER | Entry Grade Id |
| PER_POSITIONS_EIT_EFF | ENTRY_STEP_ID | NUMBER | Entry Step Id |
| PER_POSITIONS_EIT_EFF | JOB_ID | NUMBER | Job Id |
| PER_POSITIONS_EIT_EFF | LOCATION_ID | NUMBER | Location Id |
| PER_POSITIONS_EIT_EFF | POSITION_TYPE | VARCHAR2 | Position Type |
| PER_POSITIONS_EIT_EFF | UNION_ID | NUMBER | Union Id |
| PER_POSITIONS_LEG_EFF | EFFECTIVE_START_DATE | DATE | Effective Start Date |