PRC_TEAMCODE_VW

(SQL View)
Index Back

Sales Team Code Table

This record is the header for the Support Team Table. It is the parent of TEAM_MEMBERS. This is an optional record.

SELECT setid , support_team_cd , effdt , descr FROM PS_TEAM_CODE_TBL

  • Related Language Record: PRC_TEAMCODE_LV
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 SUPPORT_TEAM_CD Character(6) VARCHAR2(6) NOT NULL Support Team Code
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 EOEP_CHAR Character(254) VARCHAR2(254) NOT NULL Long field