OI_TFLT_REQ (SQL Table)	Index Back
Allocation Request

OI_TFLT_REQ

(SQL Table)

Allocation Request

# 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 REQUEST_NBR Number(4,0) SMALLINT NOT NULL Request Number

4 OI_TFLT_PROC_TYPE Character(1) VARCHAR2(1) NOT NULL Process Type
D=Delete Values
F=Flatten Tree
Default Value: F

5 OTBI_SRC_INSTANCE Number(15,4) DECIMAL(14,4) NOT NULL OTBI Process Instance
Prompt Table: OI_TFLT_LOG_VW

6 DATE_REQ_OPTION2 Character(1) VARCHAR2(1) NOT NULL Request Date Option
A=As-Of Date
S=System Date
Default Value: S

7 AS_OF_DATE Date(10) DATE As of Date
Default Value: %date

8 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
Prompt Table: OI_TFLT_FLD_VW

9 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SETID_TBL

10 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_PC_NONVW

11 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
Prompt Table: %EDITTABLE

12 TREE_EFFDT Date(10) DATE Effective date of the Tree
Prompt Table: %EDITTABLE2

13 FORCE_PROCESS_SW Character(1) VARCHAR2(1) NOT NULL Generic force processing switch
Y/N Table Edit
Default Value: N

14 PROCESS_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Process Frequency
A=Always Process
N=Don't Run
O=Process Once
Default Value: N

15 PROCESS_STATUS Character(1) VARCHAR2(1) NOT NULL Process Status
A=Active
C=Successfully Completed
E=Completed With Errors
N=Not Yet Processed
P=Processing Now
X=No Success
Default Value: N

16 PROCESS_ORIG Character(1) VARCHAR2(1) NOT NULL Process Origin
N=Other Source
P=Process Scheduler
Default Value: N

17 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

18 DTTM_STAMP_SEC DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	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	REQUEST_NBR	Number(4,0)	SMALLINT NOT NULL	Request Number
4	OI_TFLT_PROC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Process Type D=Delete Values F=Flatten Tree Default Value: F
5	OTBI_SRC_INSTANCE	Number(15,4)	DECIMAL(14,4) NOT NULL	OTBI Process Instance Prompt Table: OI_TFLT_LOG_VW
6	DATE_REQ_OPTION2	Character(1)	VARCHAR2(1) NOT NULL	Request Date Option A=As-Of Date S=System Date Default Value: S
7	AS_OF_DATE	Date(10)	DATE	As of Date Default Value: %date
8	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD). Prompt Table: OI_TFLT_FLD_VW
9	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SETID_TBL
10	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_PC_NONVW
11	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name Prompt Table: %EDITTABLE
12	TREE_EFFDT	Date(10)	DATE	Effective date of the Tree Prompt Table: %EDITTABLE2
13	FORCE_PROCESS_SW	Character(1)	VARCHAR2(1) NOT NULL	Generic force processing switch Y/N Table Edit Default Value: N
14	PROCESS_FREQUENCY	Character(1)	VARCHAR2(1) NOT NULL	Process Frequency A=Always Process N=Don't Run O=Process Once Default Value: N
15	PROCESS_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Process Status A=Active C=Successfully Completed E=Completed With Errors N=Not Yet Processed P=Processing Now X=No Success Default Value: N
16	PROCESS_ORIG	Character(1)	VARCHAR2(1) NOT NULL	Process Origin N=Other Source P=Process Scheduler Default Value: N
17	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
18	DTTM_STAMP_SEC	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.