SPR_EXPVAR_PREF

(SQL Table)
Index Back

SP Expense Variance Graph Pref

sPro Expense Variance Graphing Preferences

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 PAGE_NAME Character(18) VARCHAR2(18) NOT NULL Page Name
3 SPR_EXP_GPH_COUNTS Character(1) VARCHAR2(1) NOT NULL Expense Graph Group
4 POAMOUNT_YN Character(1) VARCHAR2(1) NOT NULL Purchase Order Amount
N=No
Y=Yes

Y/N Table Edit

Default Value: Y

5 SPR_TOTAL_TIME_YN Character(1) VARCHAR2(1) NOT NULL Y/N Field for Total Amount for Time
N=No
Y=Yes

Y/N Table Edit

Default Value: N

6 SPR_TOTAL_EXPNS_YN Character(1) VARCHAR2(1) NOT NULL Y/N Field for Total Expenses
N=No
Y=Yes

Y/N Table Edit

Default Value: N

7 SPR_TOTAL_AMT_YN Character(1) VARCHAR2(1) NOT NULL Y/N Field for Total Amount from Time plus Expenses
N=No
Y=Yes

Y/N Table Edit

Default Value: Y

8 SPR_AVAIL_AMT_YN Character(1) VARCHAR2(1) NOT NULL Y/N Field for Available Amount
N=No
Y=Yes

Y/N Table Edit

Default Value: Y