RE_CDNT_AET(SQL Table) |
Index Back |
|---|---|
Critical Dates State RecordCritical Dates State Record used for processing notifications. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPT_DATE | Date(10) | DATE | Option Date |
| 3 | SCHED_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Notifications Enabled - Active/Inactive
1=Inactive 2=Active |
| 4 | START_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Start Option for option schedule
1=On the Lease Start Date 2=Use Action Date 3=On a Specific Date |
| 5 | START_ENUM | Number(4,0) | SMALLINT NOT NULL | Notification Start Date |
| 6 | START_PRD | Character(1) | VARCHAR2(1) NOT NULL |
Start Period Options - Critical Dates
1=Days 2=Months 3=Years |
| 7 | FREQ_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Notification Frequency Option
1=Daily 2=Weekly 3=Monthly 4=Yearly 5=Never |
| 8 | FREQ_ENUM | Number(4,0) | SMALLINT NOT NULL | Frequency - Day |
| 9 | FREQ_MNTH_NBR | Number(2,0) | SMALLINT NOT NULL | Monthly Frequency |
| 10 | FREQ_DAY_NBR | Number(2,0) | SMALLINT NOT NULL | Frequency Day |
| 11 | FREQ_DOW | Number(6,0) | INTEGER NOT NULL | Frequency - Day of Week |
| 12 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 13 | LAST_GEN_DT | Date(10) | DATE | Last Notification Generation Date |
| 14 | NOTIFY_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Recieve Notification |
| 15 | LEASE_START_DT | Date(10) | DATE | Lease Start Date |
| 16 | LEASE_NAME | Character(60) | VARCHAR2(60) NOT NULL | Lease Name |
| 17 | LS_NBR | Character(10) | VARCHAR2(10) NOT NULL | Lease Number, User Enterable or Generated Sequence Number |
| 18 | INSTANCE_NAME | Character(60) | VARCHAR2(60) NOT NULL | Lease Option Name |
| 19 | LS_KEY | Number(15,0) | DECIMAL(15) NOT NULL | Lease Key, Unique Key |
| 20 | LS_OPTION_SEQ | Number(10,0) | DECIMAL(10) NOT NULL | Lease Option Sequence Key |
| 21 | OPT_RECIP_SEQ | Number(10,0) | DECIMAL(10) NOT NULL | Option Recipient Key |
| 22 | SCHEDULE_KEY | Number(10,0) | DECIMAL(10) NOT NULL | Schedule key |
| 23 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |
| 24 | MAIL_TEMPLATE | Long Character(300) | VARCHAR2(300) | Mail Template Field to store Lease Options Mail Template |
| 25 | CNTCT_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Contact Sequence Number |
| 26 | RECORDNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record Name
01=MASTER_ITEM_EC 02=INV_ITEMS_EC 03=BU_ITM_INV_EC 04=BU_ITM_WTVL_EC 05=ITEM_SUPPLIER_EC 06=ITM_SUPP_LOC_EC 07=ITM_VNDR_UOM_EC 08=ITM_VND_UMPR_EC 09=INV_ITM_UOM_EC 10=PUR_ITM_ATTR_EC 13=EN_REVISION_EC 14=ITEM_MFG_GPO_EC 15=ITEM_MFG_EC 16=ITEM_CAT_EC |
| 27 | TEMP_DT | Date(10) | DATE | Temp Date |
| 28 | AS_OF_DATE | Date(10) | DATE | As of Date |
| 29 | MESSAGE_TEXT_254 | Character(254) | VARCHAR2(254) NOT NULL | Message Text |
| 30 | DESCRLONG | Long Character | CLOB | Long Description |