SFA_PU_SPKG_BND

(SQL View)
 Index Back

Bind for Population Update

This table hosts required fields for multiple records for Population Update.

SELECT DISTINCT A.EMPLID , B.NAME , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 FROM PS_STDNT_PKG_VAR A , PS_SCC_PRI_NAME_VW B WHERE A.EMPLID = B.EMPLID

  • Parent record: STUDENT_AID

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

    Prompt Table: PEOPLE_SRCH

    2 NAME Character(50) VARCHAR2(50) NOT NULL Name
    3 RATING_CMP10 Character(5) VARCHAR2(5) NOT NULL Rating Component #10

    Prompt Table: RTNG_CMPDEF_TBL

    4 RATING_CMP11 Character(5) VARCHAR2(5) NOT NULL Rating Component #11

    Prompt Table: RTNG_CMPDEF_TBL

    5 RATING_CMP12 Character(5) VARCHAR2(5) NOT NULL Rating Component #12

    Prompt Table: RTNG_CMPDEF_TBL

    6 RATING_CMP13 Character(5) VARCHAR2(5) NOT NULL Rating Component #13

    Prompt Table: RTNG_CMPDEF_TBL

    7 RATING_CMP14 Character(5) VARCHAR2(5) NOT NULL Rating Component #14

    Prompt Table: RTNG_CMPDEF_TBL

    8 RATING_CMP15 Character(5) VARCHAR2(5) NOT NULL Rating Component #15

    Prompt Table: RTNG_CMPDEF_TBL

    9 RATING_CMP16 Character(5) VARCHAR2(5) NOT NULL Rating Component #16

    Prompt Table: RTNG_CMPDEF_TBL

    10 RATING_CMP17 Character(5) VARCHAR2(5) NOT NULL Rating Component #17

    Prompt Table: RTNG_CMPDEF_TBL

    11 RATING_CMP18 Character(5) VARCHAR2(5) NOT NULL Rating Component #18

    Prompt Table: RTNG_CMPDEF_TBL

    12 RATING_CMP19 Character(5) VARCHAR2(5) NOT NULL Rating Component #19

    Prompt Table: RTNG_CMPDEF_TBL

    13 RATING_CMP1 Character(5) VARCHAR2(5) NOT NULL Rating Component #1
    14 RATING_CMP2 Character(5) VARCHAR2(5) NOT NULL Rating Component #2
    15 RATING_CMP20 Character(5) VARCHAR2(5) NOT NULL Rating Component #20

    Prompt Table: RTNG_CMPDEF_TBL

    16 RATING_CMP3 Character(5) VARCHAR2(5) NOT NULL Rating Component #3

    Prompt Table: RTNG_CMPDEF_TBL

    17 RATING_CMP4 Character(5) VARCHAR2(5) NOT NULL Rating Component #4

    Prompt Table: RTNG_CMPDEF_TBL

    18 RATING_CMP5 Character(5) VARCHAR2(5) NOT NULL Rating Component #5

    Prompt Table: RTNG_CMPDEF_TBL

    19 RATING_CMP6 Character(5) VARCHAR2(5) NOT NULL Rating Component #6

    Prompt Table: RTNG_CMPDEF_TBL

    20 RATING_CMP7 Character(5) VARCHAR2(5) NOT NULL Rating Component #7

    Prompt Table: RTNG_CMPDEF_TBL

    21 RATING_CMP8 Character(5) VARCHAR2(5) NOT NULL Rating Component #8

    Prompt Table: RTNG_CMPDEF_TBL

    22 RATING_CMP9 Character(5) VARCHAR2(5) NOT NULL Rating Component #9

    Prompt Table: RTNG_CMPDEF_TBL

    23 RATING_CMP_VALUE1 Number(10,4) DECIMAL(9,4) NOT NULL Rating Value #1
    24 RATING_CMP_VALUE10 Number(10,4) DECIMAL(9,4) NOT NULL Rating Value #10
    25 RATING_CMP_VALUE11 Number(10,4) DECIMAL(9,4) NOT NULL Rating Value #11
    26 RATING_CMP_VALUE12 Number(10,4) DECIMAL(9,4) NOT NULL Rating Value #12
    27 RATING_CMP_VALUE13 Number(10,4) DECIMAL(9,4) NOT NULL Rating Value #13
    28 RATING_CMP_VALUE14 Number(10,4) DECIMAL(9,4) NOT NULL Rating Value #14
    29 RATING_CMP_VALUE15 Number(10,4) DECIMAL(9,4) NOT NULL Rating Value #15
    30 RATING_CMP_VALUE16 Number(10,4) DECIMAL(9,4) NOT NULL Rating Value #16
    31 RATING_CMP_VALUE17 Number(10,4) DECIMAL(9,4) NOT NULL Rating Value #17
    32 RATING_CMP_VALUE18 Number(10,4) DECIMAL(9,4) NOT NULL Rating Value #18
    33 RATING_CMP_VALUE19 Number(10,4) DECIMAL(9,4) NOT NULL Rating Value #19
    34 RATING_CMP_VALUE2 Number(10,4) DECIMAL(9,4) NOT NULL Rating Value #2
    35 RATING_CMP_VALUE20 Number(10,4) DECIMAL(9,4) NOT NULL Rating Value #20
    36 RATING_CMP_VALUE3 Number(10,4) DECIMAL(9,4) NOT NULL Rating Value #3
    37 RATING_CMP_VALUE4 Number(10,4) DECIMAL(9,4) NOT NULL Rating Value #4
    38 RATING_CMP_VALUE5 Number(10,4) DECIMAL(9,4) NOT NULL Rating Value #5
    39 RATING_CMP_VALUE6 Number(10,4) DECIMAL(9,4) NOT NULL Rating Value #6
    40 RATING_CMP_VALUE7 Number(10,4) DECIMAL(9,4) NOT NULL Rating Value #7
    41 RATING_CMP_VALUE8 Number(10,4) DECIMAL(9,4) NOT NULL Rating Value #8
    42 RATING_CMP_VALUE9 Number(10,4) DECIMAL(9,4) NOT NULL Rating Value #9
    43 VARIABLE_CHAR1 Character(20) VARCHAR2(20) NOT NULL User Variable Character #1
    44 VARIABLE_CHAR10 Character(20) VARCHAR2(20) NOT NULL User Variable Character #10
    45 VARIABLE_CHAR2 Character(20) VARCHAR2(20) NOT NULL User Variable Character #2
    46 VARIABLE_CHAR3 Character(20) VARCHAR2(20) NOT NULL User Variable Character #3
    47 VARIABLE_CHAR4 Character(20) VARCHAR2(20) NOT NULL User Variable Character #4
    48 VARIABLE_CHAR5 Character(20) VARCHAR2(20) NOT NULL User Variable Character #5
    49 VARIABLE_CHAR6 Character(20) VARCHAR2(20) NOT NULL User Variable Character #6
    50 VARIABLE_CHAR7 Character(20) VARCHAR2(20) NOT NULL User Variable Character #7
    51 VARIABLE_CHAR8 Character(20) VARCHAR2(20) NOT NULL User Variable Character #8
    52 VARIABLE_CHAR9 Character(20) VARCHAR2(20) NOT NULL User Variable Character #9
    53 VARIABLE_FLAG1 Character(1) VARCHAR2(1) NOT NULL User Variable Y/N Flag #1

    Y/N Table Edit

    54 VARIABLE_FLAG10 Character(1) VARCHAR2(1) NOT NULL User Variable Y/N Flag #10

    Y/N Table Edit

    55 VARIABLE_FLAG2 Character(1) VARCHAR2(1) NOT NULL User Variable Y/N Flag #2

    Y/N Table Edit

    56 VARIABLE_FLAG3 Character(1) VARCHAR2(1) NOT NULL User Variable Y/N Flag #3

    Y/N Table Edit

    57 VARIABLE_FLAG4 Character(1) VARCHAR2(1) NOT NULL User Variable Y/N Flag #4

    Y/N Table Edit

    58 VARIABLE_FLAG5 Character(1) VARCHAR2(1) NOT NULL User Variable Y/N Flag #5

    Y/N Table Edit

    59 VARIABLE_FLAG6 Character(1) VARCHAR2(1) NOT NULL User Variable Y/N Flag #6

    Y/N Table Edit

    60 VARIABLE_FLAG7 Character(1) VARCHAR2(1) NOT NULL User Variable Y/N Flag #7

    Y/N Table Edit

    61 VARIABLE_FLAG8 Character(1) VARCHAR2(1) NOT NULL User Variable Y/N Flag #8

    Y/N Table Edit

    62 VARIABLE_FLAG9 Character(1) VARCHAR2(1) NOT NULL User Variable Y/N Flag #9

    Y/N Table Edit

    63 VARIABLE_NUM1 Number(16,3) DECIMAL(15,3) NOT NULL User Variable Numeric #1
    64 VARIABLE_NUM10 Number(16,3) DECIMAL(15,3) NOT NULL User Variable Numeric #10
    65 VARIABLE_NUM2 Number(16,3) DECIMAL(15,3) NOT NULL User Variable Numerice #2
    66 VARIABLE_NUM3 Number(16,3) DECIMAL(15,3) NOT NULL User Variable Numeric #3
    67 VARIABLE_NUM4 Number(16,3) DECIMAL(15,3) NOT NULL User Variable Numeric #4
    68 VARIABLE_NUM5 Number(16,3) DECIMAL(15,3) NOT NULL User Variable Numeric #5
    69 VARIABLE_NUM6 Number(16,3) DECIMAL(15,3) NOT NULL User Variable Numeric #6
    70 VARIABLE_NUM7 Number(16,3) DECIMAL(15,3) NOT NULL User Variable Numeric #7
    71 VARIABLE_NUM8 Number(16,3) DECIMAL(15,3) NOT NULL User Variable Numeric #8
    72 VARIABLE_NUM9 Number(16,3) DECIMAL(15,3) NOT NULL User Variable Numeric #9