INSTALLATION_TE

(SQL Table)
Index Back

Installation Mobile T&E

Contains fields to define how data is filtered when it is synced.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
2 TE_EXP_DAYS Number(3,0) SMALLINT NOT NULL Expense Reports

Default Value: 60

3 TE_TIME_DAYS Number(3,0) SMALLINT NOT NULL Time Reports

Default Value: 60

4 TE_CNTRL_DAYS Number(3,0) SMALLINT NOT NULL Setup Data

Default Value: 60

5 TE_CURR_OVRD Character(1) VARCHAR2(1) NOT NULL Allow currency selection

Y/N Table Edit

Default Value: N

6 TE_PROJECT_MAX Number(3,0) SMALLINT NOT NULL Maximum Number of Projects

Default Value: 25

7 TE_LOCATION_MAX Number(3,0) SMALLINT NOT NULL Maximum Number of Locations

Default Value: 25

8 TE_FILTER_SYNC Character(1) VARCHAR2(1) NOT NULL Turn on Filtered Sync.

Y/N Table Edit

Default Value: Y