LM_ADHC_LRN_IDEOAW_SEQ_NBREOAWTHREAD_IDEOAWPRCS_IDSTAGE_NBRLM_AP_CM_ADH_VW(SQL View) |
Index Back |
|---|---|
Adhoc Lrng Approval CommentsThis view has the all the approval comments for supplemental learning. |
| %Sql(LM_APR_COMMENTS_SQL,LM_ADH_APR_XREF,LM_ADHC_LRN_ID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_ADHC_LRN_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Adhoc Learning Id |
| 2 | EOAW_SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | EOAW comment sequence number |
| 3 | EOAWTHREAD_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Approval Framework Thread ID |
| 4 | EOAWPRCS_ID |
Character(30) | VARCHAR2(30) NOT NULL | Approval Process ID |
| 5 | STAGE_NBR |
Number(3,0) | SMALLINT NOT NULL | Stage Number |
| 6 | EOAWDTTM_MODIFIED | DateTime(26) | TIMESTAMP | Datetime modified |
| 7 | COMMENTS | Long Character | CLOB | Comment |
| 8 | LM_PERSON_ID | Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |
| 9 | LM_NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Name Display field |
| 10 | LM_DISPLAY_DT_TEXT | Character(100) | VARCHAR2(100) NOT NULL | Display Date |