GVT_SVCDEP_VW

(SQL View)
 Index Back

Military Deposit Runcntl Srch

Military Deposit Run Control Seach View

SELECT A.EMPLID , B.NAME , A.SEQ_NO , A.GVT_STATUS_ACCT FROM PS_GVT_SVCDEP_TBL A , PS_PERSON_NAME B WHERE A.EMPLID=B.EMPLID

  • Parent record: GVT_RUN_CNTL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 NAME Character(50) VARCHAR2(50) NOT NULL Name
    3 SEQ_NO Number(2,0) SMALLINT NOT NULL Sequence Number
    4 GVT_STATUS_ACCT Character(3) VARCHAR2(3) NOT NULL Status Account
    1=Open
    2=Cancelled
    3=Closed