Table Name: hrusp_namefmt_cmts
|
Purpose: |
This table is meant to store comments entered by the user in login language.
|
||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name |
|
user_name |
nvarchar(25) |
NOT NULL |
Login user name |
Yes |
hrusername |
|
language_code |
int |
NOT NULL |
Language Code for User name format |
Yes |
hrlangid |
|
namefmt_comments |
nvarchar(2000) |
NULL |
remarks made by login user |
No |
hrnotes |
Table Name: hrusp_object_count
|
Purpose: |
This table is meant for storing Backend and front end object information for userPreference component.
|
||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name |
|
object_name |
nvarchar(255) |
NOT NULL |
Object Name |
Yes |
hrtext255 |
|
object_type |
nvarchar(5) |
NULL |
Object Type (Table, View, Index, etc) |
No |
hrcode |
|
base_or_ext_flag |
nvarchar(3) |
NULL |
Column base_or_ext_flag can have the following values only : 'B' when the objects are created internally, and 'E' when the objects are created externally. |
No |
hrflag |
Table Name: hrusrp_namefmt
|
Purpose: |
This table stores the user’s preferences of name format. Meta data for name format are defined in Process Parameters component.
|
||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name |
|
user_name |
nvarchar(25) |
NOT NULL |
Login user name |
Yes |
hrusername |
|
name_format |
nvarchar(40) |
NULL |
Name format preferred by login user Example: FML LMF |
No |
hrparvalue |
|
login_ou_code |
nvarchar(12) |
NOT NULL |
Login in org unit from which preference was set. This is just for info |
No |
hrorgunitcode |