FOEMPLINTSU_UPG

(SQL Table)
 Index Back

Interview Summary

  • Parent Record Of FOEMPINTSIT_UPG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    3 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPRDEFTBL_UPG.SETID

    Prompt Table: SETID_TBL

    4 FO_TEMPLATE_TYPE Character(4) VARCHAR2(4) NOT NULL Form Type
    5 TEMPLATE_CODE Character(6) VARCHAR2(6) NOT NULL Form Code

    Prompt Table: FO_TEMPLATE_HDR

    6 INTVW_DATE Date(10) DATE Interview Date

    Default Value: %date

    7 FO_TIME Time(15) TIMESTAMP Time
    8 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Default Value: OPRDEFTBL_UPG.OPRID

    Prompt Table: OPRID_VW

    9 COMMENTS Long Character CLOB Comment