HCSC_CLK_PD_KEY

(SQL Table)
 Index Back

Component Group

Used to group components under a Group ID.

  • Parent record: HCSC_CLK_PD_LVL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HCSC_CLK_PROD_ID Character(4) VARCHAR2(4) NOT NULL Product owner ID
    2 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    3 HCSC_CLK_LCKLEVEL Character(10) VARCHAR2(10) NOT NULL Lock level
    4 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: HCSC_CLK_FLD_VW

    5 HCSC_CLK_SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence Number
    6 HCSC_CLK_MAINTRESP Character(1) VARCHAR2(1) NOT NULL Maintanance Responsibility Field - It has 2 translate values - PeopleSoft, Customer
    C=Customer
    P=PeopleSoft
    7 HCSC_CLK_KEYTYPE Character(3) VARCHAR2(3) NOT NULL Key type- Primary, Alternate
    ALT=Alternate Key
    PRI=Primary Key

    Default Value: PRI

    8 HCSC_CLK_RECNM Character(15) VARCHAR2(15) NOT NULL Search Record Name

    Prompt Table: PSRECDEFN

    9 SQLID Character(30) VARCHAR2(30) NOT NULL SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE
  • SQLTYPE = 0: SQL object name
  • SQLTYPE = 1: Application Engine Step Identifier
  • SQLTYPE = 2: RECNAME
  • SQLTYPE = 6: Application Engine XSLT (XML definition)

    Prompt Table: HCSC_CLK_SQL_VW