ESIGN_CATEGORY(SQL Table) |
Index Back |
|---|---|
Acknowledgement CategoryAcknowledgement Category |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(15) | VARCHAR2(15) NOT NULL | Activity Guide Category | |
| 2 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 3 | ESIGN_SRCH_ES_ID | Character(1) | VARCHAR2(1) NOT NULL |
Search Options - Acknowledgement ID
N=No Y=Yes Default Value: Y |
| 4 | ESIGN_SRCH_USERID | Character(1) | VARCHAR2(1) NOT NULL |
Search Options - User ID
N=No Y=Yes Default Value: Y |
| 5 | ESIGN_USER_ID_LBL | Character(30) | VARCHAR2(30) NOT NULL | Field Label |
| 6 | ESIGN_USERID_PRMPT | Character(15) | VARCHAR2(15) NOT NULL |
AGC Context Prompt Table
Prompt Table: ESIGN_PRMPT_VW |
| 7 | ESIGN_SRCH_DTTM | Character(1) | VARCHAR2(1) NOT NULL |
Search Options - User ID
N=No Y=Yes Default Value: Y |
| 8 | ESIGN_SRCH_ACKUSER | Character(1) | VARCHAR2(1) NOT NULL |
Search Options - Acknowledgement ID
N=No Y=Yes Default Value: N |
| 9 | ESIGN_ACKUSER_LBL | Character(30) | VARCHAR2(30) NOT NULL | Field Label |
| 10 | ESIGN_ACKUSR_PRMPT | Character(15) | VARCHAR2(15) NOT NULL |
AGC Context Prompt Table
Prompt Table: ESIGN_PRMPT_VW |