HRS_JO_DTNM_ANS

(SQL Table)
Index Back

Date/Numeric Questions Answer

Date/Numeric Questions Answer Record.

  • Parent record: HRS_JO_QSTN
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
    2 HRS_JO_RQMT_SEQ Number(3,0) SMALLINT NOT NULL Job opening requirement sequence
    3 HRS_QSTN_ID Number(15,0) DECIMAL(15) NOT NULL Question ID
    4 HRS_SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence Number
    5 HRS_CONDITION Character(1) VARCHAR2(1) NOT NULL Condition
    A=AND
    W=WHERE
    6 HRS_OPERATOR Character(4) VARCHAR2(4) NOT NULL Operator
    EQ=Equals
    GT=Greater than
    GTEQ=Greater than or equal to
    LT=Less than
    LTEQ=Less than or equal to
    NTEQ=Not equal to
    7 HRS_DATE_VAL Date(10) DATE Date Value
    8 HRS_NUM_VAL Signed Number(13,2) DECIMAL(11,2) NOT NULL Date Value
    9 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    10 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    11 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    12 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id