SSF_GL_TRANS

(SQL Table)
 Index Back

Direct GL Transaction Table

  • Parent Record Of SSF_GL_TRANS_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SSF_GL_TRANS_ID Character(12) VARCHAR2(12) NOT NULL GL Transaction ID
    2 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value
    3 SA_ID_TYPE Character(1) VARCHAR2(1) NOT NULL ID Type
    O=Organization
    P=Person
    4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_SF_NONVW

    5 SSF_GL_TRANS_SRC Character(2) VARCHAR2(2) NOT NULL GL Transaction Source
    01=Admissions App Web Services
    02=Official Transcript Fee
    6 SSF_GL_TRANS_STAT Character(1) VARCHAR2(1) NOT NULL GL Status indicates whether the Direct GL transaction records have been created successfully.
    1=Pending
    2=Complete
    7 SSF_GL_RUN_DT Date(10) DATE GL Run Date
    8 SSF_GL_SEQ_NUM Number(3,0) SMALLINT NOT NULL GL Sequence Number
    9 SSF_EXT_TRANS_REF Character(50) VARCHAR2(50) NOT NULL External Transaction Reference
    10 TRANS_DT Date(10) DATE Transaction Date
    11 SF_PMT_REF_NBR Character(12) VARCHAR2(12) NOT NULL Reference Nbr
    12 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

    Default Value: 0

    13 TOT_ITEM_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Item Amount Total
    14 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    15 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    16 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    17 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    18 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time