HR_EH_FLDNM_TBL(SQL Table) |
Index Back |
|---|---|
Header ID Field Name TableHeader ID Field Name Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  HR_EH_FLDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive Default Value: A |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 6 | HR_EH_LABEL | Character(30) | VARCHAR2(30) NOT NULL | Mouse Over Data: Label data |
| 7 | HR_EH_NAME_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Header Data: Check Box to show the Display field on the EH setup page for this field name
Y/N Table Edit Default Value: N |
| 8 | HR_EH_SHOW_DSP | Character(1) | VARCHAR2(1) NOT NULL |
Header Data: Check Box to show the Display field on the EH setup page for this field name
Y/N Table Edit Default Value: N |
| 9 | HR_EH_SHOW_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Header Data: Check Box to show the Type field on the EH setup page for this field name
Y/N Table Edit Default Value: N |
| 10 | HR_EH_FIELD_SRC | Character(1) | VARCHAR2(1) NOT NULL |
Source type for user list population. It could be
U: All Users
R: Role Based
S: SQL Definition
Q: Query Based
A: Application Class
A=Application Class Q=Query Based S=SQL Definition Default Value: A |
| 11 | PACKAGEROOT | Character(30) | VARCHAR2(30) NOT NULL |
Root Package ID
Prompt Table: HREH_APPPKGRTVW |
| 12 | QUALIFYPATH | Character(127) | VARCHAR2(127) NOT NULL |
Qualified Package/Class Path
Prompt Table: HREH_APPCLSPVW |
| 13 | APPCLASSID | Character(30) | VARCHAR2(30) NOT NULL |
Application Class ID
Prompt Table: HREH_APPCLSVW |
| 14 | APPCLASSMETHOD | Character(60) | VARCHAR2(60) NOT NULL | Application Class Method Name |
| 15 | SYSTEM_DATA_FLG | Character(1) | VARCHAR2(1) NOT NULL |
This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.
Default Value: N |