OPRIDRUN_CNTL_IDPrompt Table: SP_BU_RE_NONVW
Prompt Table: RE_LS_ACT_VW
Prompt Table: RE_LANDLORD_VW
Prompt Table: RE_LS_TYPE_NAME
Prompt Table: RE_PTY_LA
Prompt Table: RE_PTY_PM
Prompt Table: RE_REGION_NAME
RE_RUN_TRA_ANA(SQL Table) |
Index Back |
|---|---|
Run Control Lease InterfaceRun Control Lease Interface |
| # | 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 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_RE_NONVW |
| 4 | LS_NBR | Character(10) | VARCHAR2(10) NOT NULL |
Lease Number, User Enterable or Generated Sequence Number
Prompt Table: RE_LS_ACT_VW |
| 5 | PRINCIPAL_ID | Character(15) | VARCHAR2(15) NOT NULL |
Landlord/Tenant
Prompt Table: RE_LANDLORD_VW |
| 6 | TRANS_DT | Date(10) | DATE NOT NULL | Transaction Date |
| 7 | LSE_TYPE_CD | Character(10) | VARCHAR2(10) NOT NULL |
This field contains the code for the Lease Types
Prompt Table: RE_LS_TYPE_NAME |
| 8 | LS_ADMIN | Number(10,0) | DECIMAL(10) NOT NULL |
Lease Administrator
Prompt Table: RE_PTY_LA |
| 9 | PRTFL_MGR | Number(10,0) | DECIMAL(10) NOT NULL |
Portfolio Manager
Prompt Table: RE_PTY_PM |
| 10 | REGION | Character(30) | VARCHAR2(30) NOT NULL |
Geographic Region
Prompt Table: RE_REGION_NAME |