RE_SAR_OPTION

(SQL Table)
Index Back

Options added to a Lease

This record has all the Options added to a Lease.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SAR_ID Character(15) VARCHAR2(15) NOT NULL SAR ID
2 OPTION_SEQ Number(10,0) DECIMAL(10) NOT NULL Lease Option Sequence Key
3 OPT_DATE Date(10) DATE Option Date
4 START_DT Date(10) DATE Start Date
5 OPT_STATUS Character(1) VARCHAR2(1) NOT NULL Option Status
2=Inactive
3=Active
4=Expired

Default Value: 2

6 ENABLED Character(1) VARCHAR2(1) NOT NULL A flag indicates whether this row is enabled or not.

Y/N Table Edit

Default Value: N

7 OPTION_CD Character(20) VARCHAR2(20) NOT NULL This is used as a Key in the RE_LSE_OPTION record

Prompt Table: RE_OPTION

8 SCHEDULE_KEY Number(10,0) DECIMAL(10) NOT NULL Schedule key

Prompt Table: RE_OPT_SCHED

9 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
10 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
11 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
12 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.
13 MESSAGE_TEXT_254 Character(254) VARCHAR2(254) NOT NULL Message Text