HRS_APP_CCL_HST

(SQL Table)
Index Back

APP Work Force Contract Clause

Contract Clause for Applicants is used to store special contract clause. This table is cloned from WKF_CNT_CLAUSE.

  • Parent record: HRS_APP_CNTRACT
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
    2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
    3 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    4 HRS_CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL contract number
    5 HRS_CONTRACT_SEQ Number(3,0) SMALLINT NOT NULL contrct seq number
    6 CONTRACT_CLAUSE Character(3) VARCHAR2(3) NOT NULL Contract Clause

    Prompt Table: CNT_CLAUSE_TBL

    7 CLAUSE_STATUS Character(1) VARCHAR2(1) NOT NULL Clause Status
    1=Optional
    2=Required
    8 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    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
    13 COMMENTS Long Character CLOB Comment