SPA_TIME_HDR(SQL Table) |
Index Back |
|---|---|
Time Report HeaderThis is one of the core records forTime. It is the highest level definition for a Time Report. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_SP_NONVW |
| 2 | TIME_SHEET_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Time Sheet Unique Identifier (System Generated)
Default Value: NEXT |
| 3 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 4 | SPA_TIMESHEET_NAME | Character(30) | VARCHAR2(30) NOT NULL | Time Sheet Name |
| 5 | SP_EXTERNAL_ID | Character(80) | VARCHAR2(80) NOT NULL | External unique identifier to reference the TimeSheet. |
| 6 | PERIOD_END_DT | Date(10) | DATE NOT NULL | Represents the date termination point for a given time set utilized in cash worksheet processing. |
| 7 | PERIOD_START_DT | Date(10) | DATE | Represents the date commencement point for a given time set utilized in cash worksheet processing. |
| 8 | CALENDAR_ID | Character(2) | VARCHAR2(2) NOT NULL | Calendar ID |
| 9 | ACCOUNTING_PERIOD | Number(3,0) | SMALLINT NOT NULL | Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table. |
| 10 | TE_TEMPLATE_ID | Character(8) | VARCHAR2(8) NOT NULL |
Used to define a particular type of travel, i.e. company relocation, internal travel, etc. Determines what type of expenses and expenditure limits are associated with that particular type of travel. Established in the Structure Expenses system and chosen on the header panel of cash expense sheets.
Prompt Table: SPA_SP_RTMPL_VW |
| 11 | CREATION_DT | Date(10) | DATE |
Creation Date
Default Value: %date |
| 12 | APPROVAL_DT | Date(10) | DATE | Date of Approval |
| 13 | APPROVAL_OPRID | Character(30) | VARCHAR2(30) NOT NULL | A system generated value that reflects the operator that approved a given transaction. |
| 14 | SUBMISSION_DATE | Date(10) | DATE | Submission Date |
| 15 | RESUBMISSION_DT | Date(10) | DATE | Resubmission Date |
| 16 | LAST_UPDATE_DT | Date(10) | DATE | Last Updated |
| 17 | OPRID_LAST_UPDT | Character(30) | VARCHAR2(30) NOT NULL | Last User to Update |
| 18 | OPRID_ENTERED_BY | Character(30) | VARCHAR2(30) NOT NULL | Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes |
| 19 | TIME_HDR_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Time Line Status
ADJ=Adjusted APR=Approved DEN=Denied LAJ=Line Adjusted LDN=Line Denied LPD=Line Pending OPN=Open PND=Pending SUB=Submitted Default Value: OPN |
| 20 | TIME_ADJUSTED_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Flag to indicate timesheet has been adjusted
A=Adjusted N=Not Adjusted Default Value: N |
| 21 | TRC_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Time Category Status
M=Manually Assigned O=Approver Overridden S=System Generated Default Value: S |
| 22 | EXT_APPROVAL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Ext_approval_flg - Approval required for an external approved timesheet?
Y/N Table Edit Default Value: N |
| 23 | COMMENTS | Long Character | CLOB | Comment |