SPR_EXPVAR_PREF(SQL Table) |
Index Back |
---|---|
SP Expense Variance Graph PrefsPro 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 |