BUSINESS_UNITPrompt Table:
RE_BU_SRCH
Set Control Field: BUSINESS_UNIT
LS_NBRPrompt Table: RE_PARTY_LA
RE_CRTICDT(SQL View) |
Index Back |
|---|---|
Critical Date Inquiry ViewThe view for the Critical Dates Inquiry report. |
| SELECT B.BUSINESS_UNIT , B.LS_NBR , B.LEASE_NAME , B.LS_ADMIN , A.LS_KEY , A.LS_OPTION_SEQ , A.SCHEDULE_KEY , C.OPTION_CD , C.INSTANCE_NAME , A.OPT_DATE , A.MESSAGE_TEXT_254 FROM PS_RE_LS_OPTION A , PS_RE_LS B , PS_RE_OPTION C WHERE A.LS_KEY = B.LS_KEY AND A.OPTION_CD = C.OPTION_CD AND %CurrentDateIn BETWEEN C.EFFDT AND C.END_EFFDT AND C.SETID = ( SELECT D.SETID FROM PS_SET_CNTRL_REC D WHERE D.SETCNTRLVALUE = B.BUSINESS_UNIT AND D.RECNAME = 'RE_OPTION') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
RE_BU_SRCH
|
| 2 | LS_NBR |
Character(10) | VARCHAR2(10) NOT NULL | Lease Number, User Enterable or Generated Sequence Number |
| 3 | LEASE_NAME | Character(60) | VARCHAR2(60) NOT NULL | Lease Name |
| 4 | LS_ADMIN | Number(10,0) | DECIMAL(10) NOT NULL |
Lease Administrator
Prompt Table: RE_PARTY_LA |
| 5 | LS_KEY | Number(15,0) | DECIMAL(15) NOT NULL | Lease Key, Unique Key |
| 6 | LS_OPTION_SEQ | Number(10,0) | DECIMAL(10) NOT NULL | Lease Option Sequence Key |
| 7 | SCHEDULE_KEY | Number(10,0) | DECIMAL(10) NOT NULL | Schedule key |
| 8 | OPTION_CD | Character(20) | VARCHAR2(20) NOT NULL | This is used as a Key in the RE_LSE_OPTION record |
| 9 | INSTANCE_NAME | Character(60) | VARCHAR2(60) NOT NULL | Instance Name |
| 10 | OPT_DATE | Date(10) | DATE NOT NULL | Option Date |
| 11 | MESSAGE_TEXT_254 | Character(254) | VARCHAR2(254) NOT NULL | Message Text |