HS_SS_TEST_DAT

(SQL Table)
 Index Back

SS Test Details

Test Details workflow record for self service.

  • Related Language Record: HS_SS_TEST_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    2 ACTION_DT_SS Date(10) DATE NOT NULL Transaction Date
    3 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    4 HS_EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID for Health and Safety

    Prompt Table: HS_PER_ORG_ASGN

    5 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

    Prompt Table: REG_REGION_TBL

    6 TEST_CODE Character(4) VARCHAR2(4) NOT NULL Code for type of test

    Prompt Table: HS_TEST_TBL

    7 START_DATE Date(10) DATE NOT NULL Start Date for Gen Standing PO
    8 END_DATE Date(10) DATE End Date
    9 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    10 HS_TEST_RESULT Character(2) VARCHAR2(2) NOT NULL Test Result
    1=Positive
    10=Not Applicable
    11=Normal
    12=Abnormal
    2=Negative
    3=Pass
    4=Fail
    5=Detected
    6=Not Detected
    7=Test Invalid
    8=Test Not Done
    9=Test Not Performed
    11 HS_TEST_METHOD Character(2) VARCHAR2(2) NOT NULL Test Method
    1=Blood
    10=Tissue
    11=Urine
    12=X-ray
    13=MRI
    14=CT Scan
    15=Mammogram
    16=Ultrasound
    2=Mouth Swab
    3=Nasal Swab
    4=Nasopharynx Swab
    5=Saliva
    6=Skin
    7=Spinal Fluid
    8=Stool
    9=Throat Swab
    12 HS_TEST_LOCATION Character(1) VARCHAR2(1) NOT NULL Test Location
    1=Workplace
    2=Other
    13 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location Set ID

    Prompt Table: SET_VLD_HR_03

    14 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: HS_LOCATION_VW

    15 HS_LOCATION Character(50) VARCHAR2(50) NOT NULL Test Location
    16 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    17 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    18 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    19 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    20 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    21 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    22 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    23 CITY Character(30) VARCHAR2(30) NOT NULL City
    24 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    25 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    26 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    27 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    28 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    29 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    30 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    31 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    32 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    33 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    34 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit
    35 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
    36 TRANSACTION_NAME Character(25) VARCHAR2(25) NOT NULL EDI Transaction Name
    37 UPD_BY_USERID Character(30) VARCHAR2(30) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements
    38 UPD_DTTM DateTime(26) TIMESTAMP Used on "_DAT" records for 8.3 Workflow Enhancements
    39 MANUAL_UPD_USERID Character(30) VARCHAR2(30) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements
    40 MANUAL_UPD_DTTM DateTime(26) TIMESTAMP Used on "_DAT" records for 8.3 Workflow Enhancements
    41 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

    42 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

    43 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

    44 WF_STATUS Character(1) VARCHAR2(1) NOT NULL Workflow Status
    A=Approved
    C=Cancelled
    D=Denied
    E=Error. Contact Administrator.
    F=Awaiting final approval
    I=In Approval Process
    M=Administrator is Processing
    N=Not Available
    P=Rework
    S=Submitted
    V=Data Saved
    45 HS_SS_STATUS Character(1) VARCHAR2(1) NOT NULL Health and Safety self-service status
    A=Received
    D=Employee Declined
    M=More Information Requested
    N=Request Denied
    P=In Progress
    R=Approved
    S=Submitted
    V=Recorded

    Default Value: P