SPR_LOSTAY_PREF(SQL Table) |
Index Back |
|---|---|
SP Length of Stay Graph PrefsPro Length of Stay Graphing Preferences |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). | |
| 2 | Character(18) | VARCHAR2(18) NOT NULL | Page Name | |
| 3 | SPR_LOS_GPH_COUNTS | Character(1) | VARCHAR2(1) NOT NULL | Length of Stay Graph Group |
| 4 | LENGTH_OF_STAY_YN | Character(1) | VARCHAR2(1) NOT NULL |
Length of Stay Charting Preference
N=No Y=Yes Default Value: Y |
| 5 | EX_DURATION_DAY_YN | Character(1) | VARCHAR2(1) NOT NULL |
Excess Duration Days Charting Preference
N=No Y=Yes Default Value: Y |