RUN_CNTL_PORO3

(SQL Table)
 Index Back

Run Control for POROLLVW

Date Initials Reference # Description 08/29/2007 PKL F-AHAYT-01P75 9.1 PO Rollover Enhancement

# 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

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_PM_NONVW

4 SEARCH_ID Character(10) VARCHAR2(10) NOT NULL Search ID
5 PO_BUDREF_FLD_FROM Character(18) VARCHAR2(18) NOT NULL Budget Reference

Prompt Table: %EDIT_BUD_REF

6 PO_BUDREF_FLD_TO Character(18) VARCHAR2(18) NOT NULL Budget Reference

Prompt Table: %EDIT_BUD_REF

7 PO_AFFILIATE_FROM Character(5) VARCHAR2(5) NOT NULL Affiliate

Prompt Table: AFFILIATE_VW

8 PO_AFFILIATE_TO Character(5) VARCHAR2(5) NOT NULL Affiliate

Prompt Table: AFFILIATE_VW

9 PO_FUND_AFF_FROM Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1

Prompt Table: %EDIT_INTRA01

10 PO_FUND_AFF_TO Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1

Prompt Table: %EDIT_INTRA01

11 PO_OPR_AFF_FROM Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate

Prompt Table: %EDIT_INTRA02

12 PO_OPR_AFF_TO Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate

Prompt Table: %EDIT_INTRA02

13 PO_BU_PC_FROM Character(5) VARCHAR2(5) NOT NULL PC Business Unit

Prompt Table: SP_BU_PC_NONVW

14 PO_BU_PC_TO Character(5) VARCHAR2(5) NOT NULL PC Business Unit

Prompt Table: SP_BU_PC_NONVW

15 PO_PROJECT_ID_FROM Character(15) VARCHAR2(15) NOT NULL Project

Prompt Table: %EDIT_PROJECT

16 PO_PROJECT_ID_TO Character(15) VARCHAR2(15) NOT NULL Project

Prompt Table: %EDIT_PROJECT

17 BUDREF_OPER Character(1) VARCHAR2(1) NOT NULL Budget Reference
1==
2=<>
3=>
4=<
5=>=
6=<=
7=begins with
8=not begins with
9=is empty
A=between
B=not between
C=in
D=Contains
E=Not In
F=Is not empty

Default Value: 7

18 AFF_OPER Character(1) VARCHAR2(1) NOT NULL Affiliate
1==
2=<>
3=>
4=<
5=>=
6=<=
7=begins with
8=not begins with
9=is empty
A=between
B=not between
C=in
D=Contains
E=Not In
F=Is not empty

Default Value: 7

19 FUNDAFF_OPER Character(1) VARCHAR2(1) NOT NULL Fund Affiliate
1==
2=<>
3=>
4=<
5=>=
6=<=
7=begins with
8=not begins with
9=is empty
A=between
B=not between
C=in
D=Contains
E=Not In
F=Is not empty

Default Value: 7

20 OPAFF_OPER Character(1) VARCHAR2(1) NOT NULL Operating Unit Affiliate
1==
2=<>
3=>
4=<
5=>=
6=<=
7=begins with
8=not begins with
9=is empty
A=between
B=not between
C=in
D=Contains
E=Not In
F=Is not empty

Default Value: 7

21 PCBU_OPER Character(1) VARCHAR2(1) NOT NULL PC Business Unit
1==
2=<>
3=>
4=<
5=>=
6=<=
7=begins with
8=not begins with
9=is empty
A=between
B=not between
C=in
D=Contains
E=Not In
F=Is not empty

Default Value: 7

22 PROJ_OPER Character(1) VARCHAR2(1) NOT NULL Project
1==
2=<>
3=>
4=<
5=>=
6=<=
7=begins with
8=not begins with
9=is empty
A=between
B=not between
C=in
D=Contains
E=Not In
F=Is not empty

Default Value: 7

23 AFFIN Character(254) VARCHAR2(254) NOT NULL IN
24 BUDREFIN Character(254) VARCHAR2(254) NOT NULL IN
25 PO_BUDREF_PB Character(1) VARCHAR2(1) NOT NULL BUDREF
26 FAFFIN Character(254) VARCHAR2(254) NOT NULL IN
27 OPAFFIN Character(254) VARCHAR2(254) NOT NULL IN
28 PCBUIN Character(254) VARCHAR2(254) NOT NULL IN
29 PROJIN Character(254) VARCHAR2(254) NOT NULL IN
30 PO_AFF_PB Character(1) VARCHAR2(1) NOT NULL AFF
31 PO_FAFF_PB Character(1) VARCHAR2(1) NOT NULL GLBU
32 PO_OAFF_PB Character(1) VARCHAR2(1) NOT NULL GLBU
33 PO_PCBU_PB Character(1) VARCHAR2(1) NOT NULL GLBU
34 PO_PROJ_PB Character(1) VARCHAR2(1) NOT NULL GLBU
35 ACTIVITY_OPER Character(1) VARCHAR2(1) NOT NULL Activity
1==
2=<>
3=>
4=<
5=>=
6=<=
7=begins with
8=not begins with
9=is empty
A=between
B=not between
C=in
D=Contains
E=Not In
F=Is not empty

Default Value: 7

36 RESCAT_OPER Character(1) VARCHAR2(1) NOT NULL Category
1==
2=<>
3=>
4=<
5=>=
6=<=
7=begins with
8=not begins with
9=is empty
A=between
B=not between
C=in
D=Contains
E=Not In
F=Is not empty

Default Value: 7

37 RESTYPE_OPER Character(1) VARCHAR2(1) NOT NULL Resource Type
1==
2=<>
3=>
4=<
5=>=
6=<=
7=begins with
8=not begins with
9=is empty
A=between
B=not between
C=in
D=Contains
E=Not In
F=Is not empty

Default Value: 7

38 RES_SUB_CAT_OPER Character(1) VARCHAR2(1) NOT NULL Sub Category
1==
2=<>
3=>
4=<
5=>=
6=<=
7=begins with
8=not begins with
9=is empty
A=between
B=not between
C=in
D=Contains
E=Not In
F=Is not empty

Default Value: 7

39 PO_ACTIVITY_FROM Character(15) VARCHAR2(15) NOT NULL Activity ID

Prompt Table: %EDIT_ACTIVITY

40 PO_ACTIVITY_PB Character(1) VARCHAR2(1) NOT NULL activity
41 PO_ACTIVITY_TO Character(15) VARCHAR2(15) NOT NULL Activity ID

Prompt Table: %EDIT_ACTIVITY

42 ACTIVITYIN Character(254) VARCHAR2(254) NOT NULL IN
43 PO_RES_TYPE_FROM Character(5) VARCHAR2(5) NOT NULL Source Type

Prompt Table: %EDIT_RESOURCE

44 PO_RES_TYPE_TO Character(5) VARCHAR2(5) NOT NULL Source Type

Prompt Table: %EDIT_RESOURCE

45 PO_RESTYPE_PB Character(1) VARCHAR2(1) NOT NULL source type
46 RESTYPEIN Character(254) VARCHAR2(254) NOT NULL IN
47 PO_RESCAT_PB Character(1) VARCHAR2(1) NOT NULL category
48 PO_RESSUBCAT_PB Character(1) VARCHAR2(1) NOT NULL sub category
49 PO_RES_CAT_FROM Character(5) VARCHAR2(5) NOT NULL Category

Prompt Table: %EDIT_RES_CAT

50 PO_RES_CAT_TO Character(5) VARCHAR2(5) NOT NULL Category

Prompt Table: %EDIT_RES_CAT

51 PO_RES_SUBCAT_FROM Character(5) VARCHAR2(5) NOT NULL Subcategory

Prompt Table: %EDIT_RES_SUB

52 PO_RES_SUBCAT_TO Character(5) VARCHAR2(5) NOT NULL Subcategory

Prompt Table: %EDIT_RES_SUB

53 RESCATIN Character(254) VARCHAR2(254) NOT NULL IN
54 RESSUBCATIN Character(254) VARCHAR2(254) NOT NULL IN