SSR_BR_INDEX_IDSSR_BR_MSGUUIDEMPLIDJ=Qualification acquired
N=Qualification not acquired
O=Qualification undetermined
AAN=Set/Change Subscription Date
UIT=Cancel subscription
Default Value: 999
SSR_BR_ZGNI_NLD(SQL Table) |
Index Back |
|---|---|
Prior Ed general ind (staging)/* 2023-02-27, fix for bug 35141048 */ |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SSR_BR_INDEX_ID |
Character(40) | VARCHAR2(40) NOT NULL | Transaction Index ID |
| 2 | SSR_BR_MSGUUID |
Character(50) | VARCHAR2(50) NOT NULL | Message ID |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | SSR_BR_STRT_QF_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Starting qualification
J=Qualification acquired N=Qualification not acquired O=Qualification undetermined |
| 5 | SSR_BR_NBR_YWD_NLD | Character(2) | VARCHAR2(2) NOT NULL | Years without diploma |
| 6 | SSR_BR_SUBSCR_NLD | Character(4) | VARCHAR2(4) NOT NULL |
Indication Subscription
AAN=Set/Change Subscription Date UIT=Cancel subscription |
| 7 | SSR_BR_NBR_MDE_NLD | Number(3,0) | SMALLINT NOT NULL |
/* 2023-02-27, fix for bug 35141048 */
Default Value: 999 |