SPR_LOSTAY_PREF

(SQL Table)
Index Back

SP Length of Stay Graph Pref

sPro Length of Stay 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_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