SSF_TPNODE_REQD

(SQL Table)
Index Back

Third Party Node Req Detail

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

    Prompt Table: SP_BU_SF_NONVW

    2 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number

    Prompt Table: TP_CONT_SRCH_VW

    3 SSF_REQUEST_DTTM DateTime(26) TIMESTAMP NOT NULL Request DateTime
    4 LINE_SEQ_NBR Number(3,0) SMALLINT NOT NULL Line Sequence Nbr
    5 SSF_INACTIVATE_FLG Character(1) VARCHAR2(1) NOT NULL Inactivate Node

    Y/N Table Edit

    Default Value: N

    6 SSF_REQUEST_FLG Character(1) VARCHAR2(1) NOT NULL Process Request

    Y/N Table Edit

    7 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    8 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    9 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    10 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time