HR_MO_TBL(SQL Table) |
Index Back |
---|---|
HR Mouse Over TableHR Mouse Over Table that holds the ID and Description. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | HR_MO_MSE_OVR_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 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
4 | 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 |