RE_LSA_BKP_H

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LS_KEY Number(15,0) DECIMAL(15) NOT NULL Lease Key, Unique Key
2 AMND_NBR Number(3,0) SMALLINT NOT NULL Amendment Number
3 BKP_HDR_ID Number(15,0) DECIMAL(15) NOT NULL Breakpoint Header ID
4 UPDATE_FLG Character(1) VARCHAR2(1) NOT NULL Update Flag
0=No Modification
1=Add
2=Change
3=Delete

Default Value: 0

5 EFFDT_FROM Date(10) DATE Effective Date From

Default Value: %date

6 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

7 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
8 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
9 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
10 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.