HR_REPORT_TRANS

(SQL Table)
 Index Back

Reporting Chg Transaction Data

Record used to store transactional data for an Employee Reporting Change request.

  • Parent record: HR_MGR_REP_DAT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TRANSACTION_NBR Number(15,0) DECIMAL(15) NOT NULL 08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size.
    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    4 JOB_DESCR_SS Character(30) VARCHAR2(30) NOT NULL Job Title
    5 POSITION_FLAG Character(1) VARCHAR2(1) NOT NULL Position Flag
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: Y

    6 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
    7 TRANSACTION_NAME Character(25) VARCHAR2(25) NOT NULL EDI Transaction Name
    8 UPD_BY_USERID Character(30) VARCHAR2(30) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements
    9 UPD_DTTM DateTime(26) TIMESTAMP Used on "_DAT" records for 8.3 Workflow Enhancements
    10 MANUAL_UPD_USERID Character(30) VARCHAR2(30) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements
    11 MANUAL_UPD_DTTM DateTime(26) TIMESTAMP Used on "_DAT" records for 8.3 Workflow Enhancements
    12 SS_STAT_INDICATOR Character(1) VARCHAR2(1) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements
    A=Approved
    B=CI failed - Errors & Warnings
    C=Cancelled
    D=Denied
    E=Errors Encountered
    I=In Approval Process
    M=Administrator Action Required
    S=Success
    W=Warnings Encountered

    Default Value: I

    13 SS_WARNING_FLG Character(1) VARCHAR2(1) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements

    Y/N Table Edit

    Default Value: N

    14 SS_FUTURE_FLG Character(1) VARCHAR2(1) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements

    Y/N Table Edit

    Default Value: N