ADM_T130_NM_PRM

(SQL Table)
Index Back

Name Order Table

ADM_T130_NM_PRM indicates the order in which the selection of an individual's name is to occur.

  • Parent record: ADDR_USAGE_TBL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Default Value: ADM_T130_PARMS.OPRID

    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

    Default Value: ADM_T130_PARMS.RUN_CNTL_ID

    3 EDI_NAME_TYPE Character(3) VARCHAR2(3) NOT NULL EDI Name Type
    01=Given Name (Name at Birth)
    02=Current Legal
    03=Alias
    04=Name of Record
    05=Previous Name
    07=Married Name
    08=Professional Name
    4 NAME_USAGE_ORDER Number(4,0) SMALLINT NOT NULL Name Usage Order