RE_OPT_RCP_AMND (SQL Table)	Index Back
Option Recip Amnd Staging tbl This is staging table for RE_OPT_RECIP table, used during amendment, for storing data from RE_OPT_RECIP table temporarily till the amendment is activated. Once the amendment is activated, the data is deleted from this table.

RE_OPT_RCP_AMND

(SQL Table)

Option Recip Amnd Staging tbl

This is staging table for RE_OPT_RECIP table, used during amendment, for storing data from RE_OPT_RECIP table temporarily till the amendment is activated. Once the amendment is activated, the data is deleted from this table.

# 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 LS_OPTION_SEQ Number(10,0) DECIMAL(10) NOT NULL Lease Option Sequence Key

3 PARTY_TYPE_CD Character(20) VARCHAR2(20) NOT NULL Party type code (Internal or External)
Prompt Table: RE_PTY_TYPE

4 OPT_RECIP_SEQ Number(10,0) DECIMAL(10) NOT NULL Option Recipient Key

5 COMPLETED Character(1) VARCHAR2(1) NOT NULL Completed
Y/N Table Edit
Default Value: N

6 DT_COMPLETED Date(10) DATE Date Completed

7 PARTY_KEY Number(10,0) DECIMAL(10) NOT NULL Party Key
Prompt Table: %EDITTABLE

#	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	LS_OPTION_SEQ	Number(10,0)	DECIMAL(10) NOT NULL	Lease Option Sequence Key
3	PARTY_TYPE_CD	Character(20)	VARCHAR2(20) NOT NULL	Party type code (Internal or External) Prompt Table: RE_PTY_TYPE
4	OPT_RECIP_SEQ	Number(10,0)	DECIMAL(10) NOT NULL	Option Recipient Key
5	COMPLETED	Character(1)	VARCHAR2(1) NOT NULL	Completed Y/N Table Edit Default Value: N
6	DT_COMPLETED	Date(10)	DATE	Date Completed
7	PARTY_KEY	Number(10,0)	DECIMAL(10) NOT NULL	Party Key Prompt Table: %EDITTABLE