| 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 |