HRS_APP_CNTCL_I

(SQL View)
 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.

SELECT HRS_PERSON_ID ,CONTRACT_NUM ,HRS_CONTRACT_SEQ ,CONTRACT_CLAUSE ,CLAUSE_STATUS ,DESCR254 ,%subrec(HRS_AUDIT_SBR, A) ,COMMENTS FROM PS_HRS_APP_CNT_CLS A

  • Parent record: HRS_APP_CNTRACT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    2 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number
    3 HRS_CONTRACT_SEQ Number(3,0) SMALLINT NOT NULL contrct seq number
    4 CONTRACT_CLAUSE Character(3) VARCHAR2(3) NOT NULL Contract Clause

    Prompt Table: CNT_CLAUSE_TBL

    5 CLAUSE_STATUS Character(1) VARCHAR2(1) NOT NULL Clause Status
    1=Optional
    2=Required
    6 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    7 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    8 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    9 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    10 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id
    11 COMMENTS Long Character CLOB Comment