SSR_APTSYRQ_HDR

(SQL Table)
Index Back

APT Sync Request Header

  • Parent Record Of SSR_APTSYRQ_DTL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SSR_APTSYNC_REQNBR Number(11,0) DECIMAL(11) NOT NULL APT Sync Request Nbr
    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 SSR_APTSYNC_REQSRC Character(2) VARCHAR2(2) NOT NULL APT Sync Request Source
    SM=APT Sync - Manual Entry
    SP=APT Sync - Pop Select
    4 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    5 SSR_APTSY_PROC_ST Character(1) VARCHAR2(1) NOT NULL Enrollment Req Process Status
    E=Errors
    M=Messages
    P=Pending
    S=Success

    Default Value: P

    6 SSR_APT_SYN_CREATE Character(1) VARCHAR2(1) NOT NULL Create APT Items

    Y/N Table Edit

    Default Value: Y

    7 SSR_APT_SYN_DELETE Character(1) VARCHAR2(1) NOT NULL Delete APT Course
    D=Set to Dropped Status
    E=As Defined in Enrol Category
    R=Set to Planned status

    Default Value: E

    8 SSR_APT_SYN_CRSEEQ Character(1) VARCHAR2(1) NOT NULL Use Course Equivalency

    Y/N Table Edit

    Default Value: Y

    9 SSR_RSLT_TYPE Character(20) VARCHAR2(20) NOT NULL Result Type
    10 SSR_RES_MAP_ID Character(12) VARCHAR2(12) NOT NULL Result Scale
    11 SSR_APT_SYN_REMOVE Character(1) VARCHAR2(1) NOT NULL Remove APT Sync Gen Sub

    Y/N Table Edit

    Default Value: N

    12 SSR_APT_SYN_REMOPT Character(1) VARCHAR2(1) NOT NULL Remove APT Sync Gen Sub Option
    A=Always
    O=Only on DD and Deleted TC

    Default Value: A

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