EMPLIDSFA_CR_AWARD_TYPESFA_CR_TYPESFA_CRC_BIO_CHG(SQL Table) |
Index Back |
|---|---|
CRC Demo ChangeKeeps track of Address, Phone and Email Change Information |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | SFA_CR_AWARD_TYPE |
Character(30) | VARCHAR2(30) NOT NULL | Award Type |
| 3 | SFA_CR_TYPE |
Character(10) | VARCHAR2(10) NOT NULL | Address, Phone or Email Type |
| 4 | SFA_EFFDT | Date(10) | DATE | Effective Date |
| 5 | SFA_CR_PHONE_NBR | Character(17) | VARCHAR2(17) NOT NULL | Phone Number |
| 6 | SFA_CR_EMAIL_ADDR | Character(128) | VARCHAR2(128) NOT NULL | Email Address |