DBA Data[Home] [Help] [Dependency Information]

TABLE: HR.PER_FORM_FUNCTIONS

Object Details
Object Name: PER_FORM_FUNCTIONS
Object Type: TABLE
Owner: HR
FND Design Data: TablePER.PER_FORM_FUNCTIONS
Subobject Name:
Status: VALID


PER_FORM_FUNCTIONS is a generic table used:(a) in PERWSEPI
for person type picklist (function = CHANGE_PERSON_TYPE) (b) in
PERWSEPI for navigation zone picklist (function = NAVIGATE).


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Unique Key: PER_FORM_FUNCTION_UK
  1. ColumnFORM
  2. ColumnFUNCTION
  3. ColumnRESULT
  4. ColumnINPUT
  5. ColumnRESTRICTION_CODE
  6. ColumnRESTRICTION_VALUE
Indexes
Index Type Uniqueness Tablespace Column
PER_FORM_FUNCTION_UK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnFORM
ColumnFUNCTION
ColumnRESULT
ColumnINPUT
ColumnRESTRICTION_CODE
ColumnRESTRICTION_VALUE
Columns
Name Datatype Length Mandatory Comments
FORM VARCHAR2 (30) Yes Form name eg. PERPEEPI.
FUNCTION VARCHAR2 (40) Yes Function to be carried out eg. CHANGE_PERSON_TYPE, NAVIGATE.
RESULT VARCHAR2 (40) Yes The expected result eg. person type to appear on picklist.
INPUT VARCHAR2 (30)
Value used as a reference eg. existing person type.
RESTRICTION_CODE VARCHAR2 (10)
Form customization restriction code e.g. value relating to PERSON_TYPE.
RESTRICTION_VALUE VARCHAR2 (80)
Value that is restricted by the customization.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT FORM
,      FUNCTION
,      RESULT
,      INPUT
,      RESTRICTION_CODE
,      RESTRICTION_VALUE
FROM HR.PER_FORM_FUNCTIONS;

Dependencies

[top of page]

HR.PER_FORM_FUNCTIONS does not reference any database object

HR.PER_FORM_FUNCTIONS is referenced by following:

SchemaHR
ViewPER_FORM_FUNCTIONS#