UD_VARIABLE_VW2(SQL View) |
Index Back |
---|---|
User Defined Depr Variables |
select a.ud_variable, a.descr, a.ud_assign_to_flag, a.ud_initialize_flag from PS_UD_VARIABLE_TBL a where a.ud_assign_to_flag = 'Y' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | UD_VARIABLE | Character(45) | VARCHAR2(45) NOT NULL | Variable |
2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
3 | UD_ASSIGN_TO_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Assign to Variable |
4 | UD_INITIALIZE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Initialize |