MU_SETUP_DTLVW2

(SQL View)
Index Back

MU Definition

Details of changes to be processed via Mass Update

SELECT MU_ID , MU_CHG_NUM , DATA_TYPE_CD FROM PS_MU_SETUP_DTL WHERE MU_CHG_NUM > 0

  • Parent record: MU_SETUP_TBL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 MU_ID Character(15) VARCHAR2(15) NOT NULL Mass Update ID
    2 MU_CHG_NUM Number(3,0) SMALLINT NOT NULL Change Number

    Default Value: 1

    3 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type CD
    N=Customer Data
    S=Sample Data
    Y=System Data

    Default Value: N