EX_DCAA_AET(SQL Table) |
Index Back |
---|---|
DCAA Notification State RecordDCAA Notification State Record |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
4 | AE_APPLID | Character(12) | VARCHAR2(12) NOT NULL | Program Name (see PSAEAPPLDEFN). |
5 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
6 | SELECT_ALL | Character(1) | VARCHAR2(1) NOT NULL | Select All |
7 | SEND_REMINDER | Character(1) | VARCHAR2(1) NOT NULL |
Send reminder
N=No Y=Yes |
8 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
9 | NOTIFY_PASTDUE | Character(1) | VARCHAR2(1) NOT NULL | Past Due Notice |
10 | NOTIFY_ACKNOWLEDGE | Character(1) | VARCHAR2(1) NOT NULL | Pending Acknowledgement |
11 | DCAA_APPL_FLG | Character(1) | VARCHAR2(1) NOT NULL | DCAA Enabled |
12 | OVERRIDE_DCAA_FLG | Character(1) | VARCHAR2(1) NOT NULL | Disable DCAA |
13 | TIME_SHEET_ID | Character(10) | VARCHAR2(10) NOT NULL | Time Sheet Unique Identifier (System Generated) |
14 | VERSION_NUM | Number(3,0) | SMALLINT NOT NULL | Version Number |
15 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
16 | PERIOD_END_DT | Date(10) | DATE | Represents the date termination point for a given time set utilized in cash worksheet processing. |
17 | SUBMISSION_DATE | Date(10) | DATE | Submission Date |
18 | RESUBMISSION_DT | Date(10) | DATE | Resubmission Date |
19 | OPRID_SUBMITTED_BY | Character(30) | VARCHAR2(30) NOT NULL | Operator Id of user submitting the transaction |
20 | OPRDEFNDESC | Character(30) | VARCHAR2(30) NOT NULL | Description field for a user |
21 | DATE_UNDER_RPT | Date(10) | DATE | Date Under Report |
22 | CUTOFF_DAYS | Number(3,0) | SMALLINT NOT NULL | Cutoff Days |
23 | CUTOFF_TIME | Time(15) | TIMESTAMP | The settlement cutoff time for a given bank/counterparty. |
24 | TIMEZONE | Character(9) | VARCHAR2(9) NOT NULL | Time Zone |
25 | RUNDTTM | DateTime(26) | TIMESTAMP | Run Date/Time |
26 | RUNTIME | Time(15) | TIMESTAMP | Process Scheduler Process Run Time |
27 | USER_OPRID | Character(30) | VARCHAR2(30) NOT NULL | User ID |
28 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |
29 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
30 | USER_OPTION_VALUE | Character(30) | VARCHAR2(30) NOT NULL | User personalization option override value. |
31 | DATETIMEVAL1 | DateTime(26) | TIMESTAMP | DateTime Value |
32 | URL_1 | Character(254) | VARCHAR2(254) NOT NULL | URL #1 |
33 | URL_2 | Character(254) | VARCHAR2(254) NOT NULL | URL #2 |