ColumnName |
Domain |
Datatype |
NULL |
Definition |
PER_DIEM_SCHEDULE_CD |
|
VARCHAR2(10) |
NO |
Name: Per Diem Schedule. Description: The identifier for the per diem schedule. |
PER_DIEM_SCHEDULE_DESC |
|
VARCHAR2(30) |
NO |
Name: Per Diem Schedule Description. Description: The Description of the per diem schedule. |
S_SOURCE_CD |
|
VARCHAR2(1) |
NO |
Name: Source. Description: Indicates the source of the rate schedules. The valid values are: C – CONUS. O – OCONUS. U - User. B – CONUS/OCONUS |
S_CONTENTS_CD |
|
VARCHAR2(1) |
NO |
Name: Contents. Description: Indicates the contents of the rate schedules. The valid values are: C – Civilian. M – Military. B - Both |
COUNTRY_REQUIRED_FL |
|
VARCHAR2(1) |
NO |
Name: Country Required Flag. Description: Logical as to whether this field is prompted for in system. |
STATE_REQUIRED_FL |
|
VARCHAR2(1) |
NO |
Name: State Required Flag. Description: Logical as to whether this field is prompted for in system. |
CITY_REQUIRED_FL |
|
VARCHAR2(1) |
NO |
Name: City Required Flag. Description: Logical as to whether this field is prompted for in system. |
COUNTY_REQUIRED_FL |
|
VARCHAR2(1) |
NO |
Name: County Required Flag. Description: Logical as to whether this field is prompted for in system. |
ACTIVE_FL |
|
VARCHAR2(1) |
NO |
Name: Active Flag. Description: Logical as to whether per diem schedule is used in system. |
MODIFIED_BY |
|
VARCHAR2(20) |
NO |
Name: Modified By. Description: The User ID of the person who last modified this record. |
ROWVERSION |
|
NUMBER(10, 0) |
NO |
Name: Row Version. Description: The number of times this record has been updated. |
TIME_STAMP |
|
DATE |
NO |
Name: Time Stamp. Description: Date and time the record was last modified. |