HR_EH_HEADER_IDEFFDTDefault Value: %date
COLUMNNUM_HRDefault Value: 1
HR_EH_ORDER_SEQDefault Value: 1
HR_EH_FLDNAMEPrompt Table: HR_EH_NMFLD_DVW
B=Parentheses
C=Comma
H=Hyphen
O=Colon
P=Pipe
S=Semicolon
Y/N Table Edit
Default Value: N
HR_EH_ROW1_TBL(SQL Table) |
Index Back |
|---|---|
Heaser ID Row 1 Config TableHeaser ID Row 1 Config Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HR_EH_HEADER_ID |
Character(15) | VARCHAR2(15) NOT NULL | Mouse Over Data: Mouse Over ID |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | COLUMNNUM_HR |
Number(6,0) | INTEGER NOT NULL |
Numeric Column Information for HCM.
Default Value: 1 |
| 4 | HR_EH_ORDER_SEQ |
Number(1,0) | SMALLINT NOT NULL |
Added in Mouse Over Label
Default Value: 1 |
| 5 | HR_EH_FLDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Field Name
Prompt Table: HR_EH_NMFLD_DVW |
| 6 | HR_EH_DELIMITER | Character(1) | VARCHAR2(1) NOT NULL |
Separator
B=Parentheses C=Comma H=Hyphen O=Colon P=Pipe S=Semicolon |
| 7 | HR_EH_DISP_PRONOUN | Character(1) | VARCHAR2(1) NOT NULL |
Show Pronoun
Y/N Table Edit |
| 8 | 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 |