LM_MRGE_DUP_TBL(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_FIRST_NAME_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
First Name
Y/N Table Edit Default Value: N |
| 2 | LM_MIDDL_NAME_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Middle Name
Y/N Table Edit Default Value: N |
| 3 | LM_LAST_NAME_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Last Name
Y/N Table Edit Default Value: N |
| 4 | LM_DOB_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Date of Birth
Y/N Table Edit Default Value: N |
| 5 | LM_GENDER_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Gender
Y/N Table Edit Default Value: N |
| 6 | LM_EMAIL_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Email
Y/N Table Edit Default Value: N |
| 7 | LM_PHONE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Phone
Y/N Table Edit Default Value: N |
| 8 | LM_ADDRESS1_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Address 1
Y/N Table Edit Default Value: N |
| 9 | LM_ADDRESS2_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Address 2
Y/N Table Edit Default Value: N |
| 10 | LM_ADDRESS3_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Address 3
Y/N Table Edit Default Value: N |
| 11 | LM_STATE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
State
Y/N Table Edit Default Value: N |
| 12 | LM_POSTAL_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Postal
Y/N Table Edit Default Value: N |
| 13 | LM_CITY_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
City
Y/N Table Edit Default Value: N |
| 14 | LM_COUNTRY_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Country
Y/N Table Edit Default Value: N |