PERSON_IDPrompt Table: SPB_PERSON_TBL
SC_FUNCTION_TYPECOOD=Coordinator
Default Value: COOD
SP_ALERT_SEQ_NUMPrompt Table: SPB_SC_DEF_ALRT
LANGUAGE_CDSPB_SCALRT_LANG(SQL Table) |
Index Back |
|---|---|
Svc Coordinator Alrts Rel LangSvc Coordinator Alrts Rel Lang |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Person ID
Prompt Table: SPB_PERSON_TBL |
| 2 | SC_FUNCTION_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Function Type
COOD=Coordinator Default Value: COOD |
| 3 | SP_ALERT_SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL |
Alert Sequence Number
Prompt Table: SPB_SC_DEF_ALRT |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | SP_ALERT_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Alert Description |