SCC_DUR_DTL

(SQL Table)
 Index Back

Data Update Rules Detail

Defines the update action to take on a Constituent Entity, Entity Type, or Entity Field.

  • Parent record: SCC_DUR_HDR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCC_DUR_ID Character(30) VARCHAR2(30) NOT NULL Data Update Rule
    2 SCC_ENTITY_ID Character(40) VARCHAR2(40) NOT NULL Entitiy ID
    3 SCC_DUR_ENTITY_TYP Character(4) VARCHAR2(4) NOT NULL Entity Type
    ALL=* All *
    NONE=None
    SHOW=* Show All Types *

    Default Value: NONE

    4 SCC_DUR_ENTITY_FLD Character(18) VARCHAR2(18) NOT NULL Entity Field

    Default Value: ALL

    Prompt Table: SCC_DUR_EFP_VW

    5 SCC_DUR_ACTION Character(1) VARCHAR2(1) NOT NULL Update Action
    A=Add If Blank
    N=Do Not Update
    S=Safe Update
    U=Update/Insert

    Default Value: N