PSA_SHARE_RULES

(SQL Table)
 Index Back

PSA Sharing Rules

This record stores sharing rules, both source and target details.

  • Parent Record Of PSA_EXCPT_EE1 PSA_EXCPT_EE2 PSA_EXCPT_LVW PSA_EXCPT_ORG PSA_EXCPT_PROJ1 PSA_EXCPT_PROJ2 PSA_EXCPT_TEAM PSA_EXCPT_VW PSA_EX_TEAM_LVW PSA_EX_TEAM_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT

    Prompt Table: SP_BU_PC_NONVW

    2 PSA_SHARE_RULE_ID Character(5) VARCHAR2(5) NOT NULL Sharing Rule ID
    3 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type

    Prompt Table: PROJ_ANTYPE_TBL

    4 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type

    Prompt Table: PROJ_RES_TYPE

    5 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category

    Prompt Table: %EDITTABLE

    6 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory

    Prompt Table: %EDITTABLE2

    7 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage
    8 OVERRIDE_SRC Character(1) VARCHAR2(1) NOT NULL Override Source

    Y/N Table Edit

    Default Value: N

    9 TRGT_ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Target Analysis Type

    Prompt Table: PROJ_ANTYPE_TBL

    10 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    11 TRGT_RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Target Source Type

    Prompt Table: PROJ_RES_TYPE

    12 TRGT_RESOURCE_CAT Character(5) VARCHAR2(5) NOT NULL Target Category

    Prompt Table: %EDITTABLE3

    13 TRGT_RES_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Target Resource SubCategory

    Prompt Table: %EDITTABLE4

    14 DISC_ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Discount Analysis Type

    Prompt Table: PROJ_ANTYPE_TBL

    15 OVERRIDE_SRC2 Character(1) VARCHAR2(1) NOT NULL Override Source

    Y/N Table Edit

    Default Value: N

    16 DISC_RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Discount Source Type

    Prompt Table: PROJ_RES_TYPE

    17 DISC_RESOURCE_CAT Character(5) VARCHAR2(5) NOT NULL Discount Resource Category

    Prompt Table: %EDITTABLE5

    18 DISC_RES_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Discount Resource SubCategory

    Prompt Table: %EDITTABLE6

    19 DISC_DESCR Character(30) VARCHAR2(30) NOT NULL Discount Description
    20 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    21 WHERE_CLAUSE_LONG2 Long Character(8192) CLOB Where Clause