PSA_EXCPT_ORG

(SQL Table)
 Index Back

Organizational Exceptions

This record stores sharing exceptions by organization.

  • Parent record: PSA_SHARE_RULES

    • # 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_BUPSAE_NONVW

    2 PSA_SHARE_RULE_ID Character(5) VARCHAR2(5) NOT NULL Sharing Rule ID

    Prompt Table: PSA_SHARE_RULES

    3 LEVEL1_CF_VAL Character(30) VARCHAR2(30) NOT NULL Resource Chartfield Level 1

    Prompt Table: BUS_UNIT_TBL_GL

    4 LEVEL2_CF_VAL Character(30) VARCHAR2(30) NOT NULL Resource Chartfield Level 2

    Prompt Table: %EDITTABLE2

    5 LEVEL3_CF_VAL Character(30) VARCHAR2(30) NOT NULL Resource Chartfield Level 3

    Prompt Table: %EDITTABLE3

    6 LEVEL4_CF_VAL Character(30) VARCHAR2(30) NOT NULL Resource Chartfield Level 4

    Prompt Table: %EDITTABLE4

    7 LEVEL5_CF_VAL Character(30) VARCHAR2(30) NOT NULL Resource Chartfield Level 5

    Prompt Table: %EDITTABLE5

    8 PRJ_LEVEL1_CF_VAL Character(30) VARCHAR2(30) NOT NULL Level 1 Chartfield

    Prompt Table: BUS_UNIT_TBL_GL

    9 PRJ_LEVEL2_CF_VAL Character(30) VARCHAR2(30) NOT NULL Level 2 Chartfield

    Prompt Table: %EDITTABLE2

    10 PRJ_LEVEL3_CF_VAL Character(30) VARCHAR2(30) NOT NULL Level 3 Chartfield

    Prompt Table: %EDITTABLE3

    11 PRJ_LEVEL4_CF_VAL Character(30) VARCHAR2(30) NOT NULL Level 4 Chartfield

    Prompt Table: %EDITTABLE4

    12 PRJ_LEVEL5_CF_VAL Character(30) VARCHAR2(30) NOT NULL Level 5 Chartfield

    Prompt Table: %EDITTABLE5

    13 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    14 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    15 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type

    Default Value: PSA_SHARE_RULES.ANALYSIS_TYPE

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

    Default Value: PSA_SHARE_RULES.RESOURCE_TYPE

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

    Default Value: PSA_SHARE_RULES.RESOURCE_CATEGORY

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

    Default Value: PSA_SHARE_RULES.RESOURCE_SUB_CAT

    19 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage
    20 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

    Default Value: 0

    21 WHERE_CLAUSE_LONG Long Character(4000) CLOB Where Clause