ST_INSTANCEDefault Value: 9999999999
0=Not Submitted
1=Submitted to Reported Time
2=Submitted to Time Admin.
3=Need to Resubmit the Session
Default Value: %Datetime
FO_POPASG_HDR(SQL Table) |
Index Back |
|---|---|
Populate Open Asgmnts HeaderThis record captures header information for timesheet sessions entered through Time Entry from Open Assignments component. A part of information from this record will be saved and synchronized with core T & L record TL_RAPID_HEADER. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ST_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL |
Submit Time Instance
Default Value: 9999999999 |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | TL_GROUP_ID | Character(7) | VARCHAR2(7) NOT NULL | Time and Labor Groups |
| 4 | PERIOD_ID | Character(12) | VARCHAR2(12) NOT NULL | Time Period ID |
| 5 | START_DT | Date(10) | DATE NOT NULL | Start Date |
| 6 | END_DT | Date(10) | DATE NOT NULL | end date |
| 7 | RAPID_TMPLT_ID | Character(10) | VARCHAR2(10) NOT NULL | Rapid Time Template |
| 8 | RAPID_UPDATE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Session Status
0=Not Submitted 1=Submitted to Reported Time 2=Submitted to Time Admin. 3=Need to Resubmit the Session |
| 9 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 10 | DTTM_STAMP | DateTime(26) | TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
Default Value: %Datetime |